Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
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.
Re: Column contains accounts which appear multiple times
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.
Re: Column contains accounts which appear multiple times
Posted by Dick Scherer on November 02, 2001 7:26 PM
Thanks Bob. I appreciate it.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.