Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you remove duplicate phone numbers in an Excel spreadsheet
How do your remove duplicate entries in an Excel spreadsheet? For example I
ran a report that lists phone numbers multiple times. I only need to have the phone number referenced one time on the excel spreadsheet. Any help would be greatly appreciated. Thank you Bridgette |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you remove duplicate phone numbers in an Excel spreadsheet
One way of doing it is with Advanced Filter. To use it, select the range
that you want to filter, go to Data-Filter-Advanced Filter, select "Copy to other location", enter the cell where you want to put the data in the "Copy to" field, check the box for "Unique records only" and click Ok. Hope this helps, Miguel. "Bridgette" wrote: How do your remove duplicate entries in an Excel spreadsheet? For example I ran a report that lists phone numbers multiple times. I only need to have the phone number referenced one time on the excel spreadsheet. Any help would be greatly appreciated. Thank you Bridgette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a macro to identify and remove duplicate data in Excel? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Im trying to remove blank rows in an Excel spreadsheet Printout | Excel Worksheet Functions | |||
can an excel spreadsheet be set to remove all hyperlinks | Excel Worksheet Functions | |||
How do I remove numerous blank rows from Excel spreadsheet? | Excel Discussion (Misc queries) |