I am trying to sort the data into lists according to the assigned "group" A,X,Y,Z
I copied the formula from the internet so it may have lost something in translation...
=IFERROR(INDEX($B$1:$B$200,AGGREGATE(15,6,1/($A$1:$A$200=$E$2)*(ROW($A$1:$A$200)-ROW($A$1)),ROW()-ROW($E$1))),"")
It looks like it works but on closer inspection many numbers are missing or put in the wrong list...
The ultimate goal is to sort the A invoices into batches of 30, then the X Y and Z into their own batches. There may be an easier way....?
Any help would be appreciated!
Bookmarks