Retain lowest values, Delete the rest

[panyagak]

Hi All.

Am in trouble.

I have a filtered data set of only Integers in an Excel sheet.
Col. 1 is Date
Col. 2 is Subject Names
Col Y is COLUMN OF INTEREST - Its where you may find Subject Names with more than one Integers eg. 9.00, 246.00, 1765.00 etc under one Subject Name. I only need 9.00!!

Have sorted the data in order of Subject Names then Col. Y in ascending order.

To avoid duplicates, I need to only retain the lowest values as and when duplicates appear. (The Duplicates Excel tool doesnt give me desired results).

Kindly help.

Thanks

 

[steve the fish]

Provided you have done the sorting the delete duplicates tool should work. In what way doesnt it?

 

[panyagak]

steve the fish

The Duplicates tool deletes in ascending order?

Patrick

 

[steve the fish]

Once it finds a value it will delete anything after that that is a duplicate. It therefore leaves the first instance. If you have sorted in the correct order it will leave the minimum. In your instance you need to sort by column Y and use the tool on column B.