Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Single Excel function to sort a list and eliminate dupes
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Single Excel function to sort a list and eliminate dupes
You can eliminate duplicates by using DataFilterAdvanced Filter
Check 'Copy to another location', specify where to place the results, and be sure to check 'Unique records only' "DickSand" wrote: ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I filter names in Excel to eliminate repeats? | Excel Discussion (Misc queries) | |||
How to eliminate xero values from pivot table and list top 10 only | Excel Worksheet Functions | |||
How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
Eliminate creating list that returns blank cells | Excel Worksheet Functions |