View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ctrl lady ctrl lady is offline
external usenet poster
 
Posts: 1
Default How to filter repeating Names


Jaleel,

thanks for the effort, but I´m affraid simple AutoFilter won´t do the
job.

I need to filter just those Names that are repeating, and left out
those that appear only once in the list.

Any other idea?

Jaleel Wrote:
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




--
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