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(
Amount,">0
"), -- is working fine but the Index fuction -- INDEX($A$6:$A$19,SMALL(IF(
Amount>0,R
OW(Amount)
-ROW(D$6)+
1),ROWS(F$
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.
learning.xlsx
Also to get rid of the #N/A in the VLOOKUP columns, add an IFERROR()
e.g. in G6:
=IFERROR(VLOOKUP($F6,$A$6:
copied down