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.