Hi,

Tools - Data - Filter - Auto Filter.
Then select visible cells, copy and paste. If you wish more tech, Dave or
Bob or Topper will reply to you.

Cheers.

Jaleel

"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