Tom Crowfoot
asked on
Consolidates (Unique) values listed in a sheet
In Excel 2010 I need to be able to list down all the unique values in a Column (Sheet1, Column A) and list those in Sheet 1 Column B (each value in a separate cell & ideally sorted Alphabetically) - The list might be any length. I know this can be done in a pivot table, but for various reasons I am keen not to use one - does anyone know a formula that can do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Attach an example workbook, it is probably possible to do using AdvancedFilter and a little VBA code.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Chosen answers addressed the original question.