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 (Data>Filet>Advanced Filter)
and then sort that data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Blaine Fray" <Blaine Fray@discussions.microsoft.com> wrote in message
news:2795CB5A-22E0-425D-8B84-0F7C0192600C@microsoft.com...
> 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.