Forum Discussion
I need my formula to not skip cells.
I would like my results to populate one after the other. No blank cells between each result.
2 Replies
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.
