I need my formula to not skip cells.

Copper Contributor

I would like my results to populate one after the other. No blank cells between each result.

2 Replies

@littlebitbent96 

 

That could be

=IFERROR(INDEX(Table1[Order Id],AGGREGATE(15,6,1/(Table1[AFID]=$F$4)/(Table1[Is Refund]=$G$4)*(ROW(Table1[AFID])-ROW(Table1[[#Headers],[AFID]])),(ROW()-ROW(Table3[[#Headers],[AFID]])))),"")

Please see the table on the right attached

Thank you! I am gonna test this out today.