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. |
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. |
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. |
All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com