| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I filter out duplicate values in Excel 2000?
Thanks!
"Gary L Brown" wrote: 1) Highlight the range that has the duplicates (include the heading). 2) DataFilterAdvanced Filter 3) Select the 'Copy to another location' button 4) Check the 'Unique records only' box 5) Select a 'Copy to:' starting cell 6) Hit 'OK' HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "missy2992" wrote: Does anyone know how I would go about filtering out duplicate values in a list. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
| Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Threaded Mode
