MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column contains accounts which appear multiple times


Posted by Dick Scherer on November 02, 2001 4:23 PM

I would like to be able to condense the multiple occurances of account numbers in a column to a single occurance of each account number in the column.


Posted by bob umlas on November 02, 2001 5:39 PM

Select the column, use Data/Filter/Advanced Filter, click Unique Values, and if you wish, click copy to another location.

Posted by Dick Scherer on November 02, 2001 7:26 PM

Thanks Bob. I appreciate it.