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

[zeegerman]

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!