Filter formula

[Komarov]

Hello,
I'm looking for filter formula or something similar.

Please see attached file.
Sheet 'data' showing location, sku and group, on different sheet i want to see all sku's for each group. So for example all sku's for tents.

Any ideas how to sort it out?
Many thanks

[Gregb11]

You say you're looking for a filter formula, but your profile says you're on V2016. Since you're asking for a FILTER formula, I'll assume you have access to MS365, but if not, this formula won't work. To get all the SKU's for TENT, you can use this formula (in cell A2 on the "Tent" sheet):

=FILTER(Data!B:B,IFERROR(Data!C:C="TENT",FALSE),"Not found")

This formula could be a little simpler, but you have "#N/A" in the list. If you didn't have those, you could just use:

=FILTER(Data!B:B,Data!C:C="TENT","Not found")

[alansidman]

You also have not indicated what your output should look like. As such I have created a Pivot Table as shown in the attached using Power Query.

[FlameRetired]

I interpreted a little differently.

In cell A2 try this formula filled down until you get blanks.

Please Login or Register  to view this content.

The copy that range and paste to the other tabs replacing "Tent" with "Sport" or whatever is appropriate.