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.