You could insert a helper column and add a formula like:

=countif(a:a,a1)
and drag down.

Then filter by this column.

Then rows with values greater than 1 have duplicates.

I'm not really sure what you want, but Chip Pearson has lots of techniques to
work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

ctrl lady wrote:

I have a huge list of clients, and some of them are repeating in "Name"
column, but have different values in other columns.

I need to filter those clients that appear more than once into separate
list.

Thanks in advance!

--
ctrl lady
------------------------------------------------------------------------
ctrl lady's Profile: http://www.excelforum.com/member.php...o&userid=21040
View this thread: http://www.excelforum.com/showthread...hreadid=572541

--

Dave Peterson