| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete duplicate values
Hi, Does anyone know if there is a way to delete duplicate values in list of names. I have a spreadsheet with about 10 000 records but each person is reprasented several times in the list. I would like to simply delete any duplicates, but going through the list deleting row by row is just driving me mad. :-) -- NNothard ------------------------------------------------------------------------ NNothard's Profile: http://www.excelforum.com/member.php...o&userid=35791 View this thread: http://www.excelforum.com/showthread...hreadid=555580 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to find duplicate values, then delete | Excel Worksheet Functions | |||
| Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
| How do I filter out duplicate values in Excel 2000? | Excel Worksheet Functions | |||
| Delete duplicate numbers | Excel Discussion (Misc queries) | |||
| How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) | |||
Threaded Mode
