Allen Prince
asked on
How to Filter an Excel list using a formuls in a cell?
Excel formula experts!
We have several categories and sub categories with values recorded in a list
I want to "filter" the list and place the values in a tabular form in a separate Excel Workbook.
loookup-filter.xlsx
We have several categories and sub categories with values recorded in a list
I want to "filter" the list and place the values in a tabular form in a separate Excel Workbook.
loookup-filter.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or you could use Index/match and array formulae: see attached.
Copy-of-loookup-filter.xlsx
Copy-of-loookup-filter.xlsx
Oops. Just saw previous answer was accepted while I was typing. I'll leave my comment for future reference if anyone reads this thread.
ASKER
Worth every dime of the annual subscription!