Array data report

I'm trying to take a table of data and separate it into a report by store location. Any help is greatly appreciated.

May 13, 2021

In A6 of each worksheet

=IFERROR(INDEX(Data!B$1:B$100, AGGREGATE(15,6,1/(--$H$1=Data!$A$1:$A$100)*ROW(Data!$A$1:$A$100),ROW()-ROW($A$5))),"")

In B6

=IFERROR(INDEX(Data!C$1:C$100, AGGREGATE(15,6,1/(--$H$1=Data!$A$1:$A$100)*ROW(Data!$A$1:$A$100),ROW()-ROW($A$5))),"")

and drag them down till end of the form

Diamond Contributor

May 13, 2021

In A6 of each worksheet

=IFERROR(INDEX(Data!B$1:B$100, AGGREGATE(15,6,1/(--$H$1=Data!$A$1:$A$100)*ROW(Data!$A$1:$A$100),ROW()-ROW($A$5))),"")

In B6

=IFERROR(INDEX(Data!C$1:C$100, AGGREGATE(15,6,1/(--$H$1=Data!$A$1:$A$100)*ROW(Data!$A$1:$A$100),ROW()-ROW($A$5))),"")

and drag them down till end of the form

Copper Contributor

May 13, 2021

This worked perfectly. Thank you!!!!

Forum Discussion