Can someone look at the excel example that I downloaded, and tell me what I did wrong? The yellow high-lighted is what I am wanting to accomplish and the light-blue is what I am getting with the formulas I created and am stumped as to what I am doing wrong?
The first part -- IF(ROWS($F$6:$F6)>COUNTIF(
"), -- is working fine but the Index fuction -- INDEX($A$6:$A$19,SMALL(IF(
6:F6))) -- is not working.
In this example, 7 names have amounts in the amount column, and if another name (for instance Susie) would have an amount that needs to dynamically show also.