Selecting The First Entry From A Column Of Entries

[godrob]

Hi Guys,

I have a column (H) full of peoples names, some of which are duplicated. What I need is to reproduce just the first entry - no duplicates in column (I)

For Example

Column H Column I

Rob Rob
Max Max
Jim Jim
Rob
Rob
Max

Thanks for any help

Regards

Rob.

 

[shades]

You can use Advanced Filter (Data > Filter > Advanced Filter), and choose Unique Records Only. Then choose location as $I$1