Use DataFilterAdvanced Filter. There is an option to filter unique
records.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Yabi" wrote in message
oups.com...
I have a column which is the name of cities. There are about 5 cities
which is repeated in 50 records (rows). I want to get the name of this
5 cities in a separate column. How can I do this?

TIA
Rasoul Khoshravan