Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter repeating Names
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter repeating Names
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter repeating Names
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter repeating Names
Dave, Thanks, your tip did the work just fine :) -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating a repeating list of names from an ever changing roster. | Excel Worksheet Functions | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Convert Local Names to Global Names | Excel Worksheet Functions | |||
How do I filter names using only the first letter? | Excel Worksheet Functions |