Unique name list

[Salamullah]

Hi

I know pivot table can bring the result but I need formula to bring unique name list in column B from list of Names in column A, please share any formula

Column A

John
Ben
John
Ben
Ben
John
Peter
Peter

Column B
John
Ben
Peter

 

[SpillerBD]

Those participating in the Office Insiders program are seeing some of the cool new array functions, like UNIQUE.

Not to be considered generally available or in use just yet, but still cool and maybe useful for certain "in-house" workbooks.

 

[Salamullah]

Hi Fluff,

additional request can I bring next columns detail of Unique name ? like in column B grade and C age

 

[Fluff]

You can do that with a Vlookup, or index/match

https://exceljet.net/excel-functions/excel-vlookup-function
https://exceljet.net/index-and-match