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.