Home |
Search |
Today's Posts |
#1
|
|||
|
|||
When sorting, how would I omit duplicates?
I am working with several data spreadsheets. I have to weekly update new
information into one spreadsheet. Question: When sorting new data with the old data, how would I omit the duplicates. |
#2
|
|||
|
|||
You can't AFAIK.
You could filter the data for unique records (DataFiletAdvanced Filter) and then sort that data. -- HTH RP (remove nothere from the email address if mailing direct) "Blaine Fray" <Blaine wrote in message ... I am working with several data spreadsheets. I have to weekly update new information into one spreadsheet. Question: When sorting new data with the old data, how would I omit the duplicates. |
#3
|
|||
|
|||
Note that if you have just one column, you could create a pivot table and
obtain the unique values, in order. Hopde this helps! Blaine Fray wrote: I am working with several data spreadsheets. I have to weekly update new information into one spreadsheet. Question: When sorting new data with the old data, how would I omit the duplicates. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel | |||
Finding Duplicates | Excel Worksheet Functions |