Hello,
I have a large spreadsheet with two columns of data (one name and the other type - see attached sample spreadsheet). I am looking to extract unique values from the name column if the type is "Adult". Next, I want to then alphabetize the unique values. How would I do that in Excel using only formulas (no VBA).
Many thanks in advance.
Bookmarks