Hii all,
I would like to list down the name of buyers.

Suppose I have:

Column A = list of items from apple to pear to bread (about 350 items)
Column B = name of buyers (Ann, Carly, Beatrice) (about 20 buyers in total)

How can I immediately make a list of the buyers name?

Thank you for the help.

Hi lily
The most simple and fast solution is to create a pivot table from your data, and drag column B into Rows field. It will create a list of unique clients.

Or you could copy column B to another column and do a Data > Remove Duplicates.