Jun 11 2019 12:53 PM
I would like my results to populate one after the other. No blank cells between each result.
Jun 11 2019 01:29 PM
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
Jun 12 2019 04:54 AM