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.
Hi ronleex324,
Excel has Advanced Filters that allow for a Unique filter. See
http://www.contextures.com/xladvfilter01.html or
http://office.microsoft.com/en-us/ex...005200178.aspx
No VBA required but you do need to have a criteral row.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks