Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying entries once
Hi,
Lets say I have a column that lists credit card numbers. But that list contains repeated entries (the same credit card 2 or more times). What i need is a column to list the cc numbers without the multiple entries of a cc. Is there a way to do this? Thx in advance for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying entries once
You can get a list of unique entries by selecting the card numbers
(including the first row - a header row) and doing Data=filter=Advanced filter. Select copy as the filtering option, click the unique checkbox in the lower left corner, designate the column where you want the result, (leave criteria blank) and clicking OK. -- Regards, Tom Ogilvy "Serge" wrote in message ... Hi, Lets say I have a column that lists credit card numbers. But that list contains repeated entries (the same credit card 2 or more times). What i need is a column to list the cc numbers without the multiple entries of a cc. Is there a way to do this? Thx in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
Displaying unique entries from a filtered list | Excel Worksheet Functions | |||
Displaying an error message if entries exceed 100% | Excel Discussion (Misc queries) | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
Retrieving the Top 10 Average Entries by displaying a third column | Excel Programming |