Auto filter

[-emma-]

Hi,

I need to be able to review a range of data (example A2:A150) and in a different cell/column, be able to produce a list of unique entries in ascending order.

Example

Column A
45
16
16
82
45
45
79
82
82

Column B
16
45
79
82

This list may be constantly changing, so new unique entries may be added. Ideally I need this list to be updating when Column A updates.

Thanks in advance for your help on this…

Emma x

 

[Yahya]

That works a treat - thank you Yahya

you are welcome