Copying single entries from duplicates in one list into a new list

Hi Everyone,

Thanks for taking the time to have a look at this problem. Could someone please help me with the following:

1. Attached is an Excel workbook: in C3:C12 there are random numbers in each cell (no blanks / no letters etc.)

2. I need a function that can create a new list (in column E) by using just one of the number entries from column B and ignoring its duplicates, and listing these single new numbers from the highest (cell E3) to the lowest.

Any help is greatly appreciated, thanks!

For your example you can use the following formula in E3 and copy down

Formula:

Please Login or Register  to view this content.

Hi XOR LX,

Thanks for your quick response, it has just been solved :-)

Hi Jose,

Great stuff, works perfectly! Thanks a lot.

I am happy to have helped. Thanks for the reputations points added.
Regards