Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I love this forum! need help again!
1) I have a contact list for previous conference years. 1999-2006. I want to find all the duplicates and have the duplicates pulled onto either another worksheet or an area on the same worksheet. 2) I had to previously pull a random sample of potential duplicates for another database import. I had about 350 random numbers from a population of 3900, and then found those contacts associated with the random numbers. This list was in alpha order. In the future is there a way to extract the contacts associated with the random number set, such that I do not have to manual deleted contacts? Future Thanks! Again, I love this forum! :) :) :) ;) :) -- EMCUE ------------------------------------------------------------------------ EMCUE's Profile: http://www.excelforum.com/member.php...o&userid=32945 View this thread: http://www.excelforum.com/showthread...hreadid=552852 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I love this forum! need help again!
Chip has lots of stuff on duplicates and comparing worksheets
see www.cpearson.com -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "EMCUE" wrote in message ... 1) I have a contact list for previous conference years. 1999-2006. I want to find all the duplicates and have the duplicates pulled onto either another worksheet or an area on the same worksheet. 2) I had to previously pull a random sample of potential duplicates for another database import. I had about 350 random numbers from a population of 3900, and then found those contacts associated with the random numbers. This list was in alpha order. In the future is there a way to extract the contacts associated with the random number set, such that I do not have to manual deleted contacts? Future Thanks! Again, I love this forum! :) :) :) ;) :) -- EMCUE ------------------------------------------------------------------------ EMCUE's Profile: http://www.excelforum.com/member.php...o&userid=32945 View this thread: http://www.excelforum.com/showthread...hreadid=552852 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I love this forum! need help again!
I will be searching a range in at least two colums, so I can find duplicates with the first and last names that match, so using the typical conditional formating to find dups, I just end up with a bunch of cells, which are contacts, that have the same first name, or last name, or whatever in in single column I need to use a function that will increase my range. any help there? -- EMCUE ------------------------------------------------------------------------ EMCUE's Profile: http://www.excelforum.com/member.php...o&userid=32945 View this thread: http://www.excelforum.com/showthread...hreadid=552852 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I love this forum! need help again!
You can concatenate the cells in a third column, assume first name is A2 and
last B2 =A2&B2 copy down as long as needed then do the duplicate tagging on the help column If you need to create a list of those two columns without any duplicates I would use datafilter advanced filter, assume the header (you need headers for advanced filter) for the first names start in A3 and the names in A4, the last names and header starts in B3 in E2 put =SUMPRODUCT(--($A$4:A4&$B$4:B4=A4&B4))=1 now select the range from the header to the last data, do datafilteradvanced filter, select copy to another location and as criteria use $E$1:$E$2 E1 needs to be blank click OK -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "EMCUE" wrote in message ... I will be searching a range in at least two colums, so I can find duplicates with the first and last names that match, so using the typical conditional formating to find dups, I just end up with a bunch of cells, which are contacts, that have the same first name, or last name, or whatever in in single column I need to use a function that will increase my range. any help there? -- EMCUE ------------------------------------------------------------------------ EMCUE's Profile: http://www.excelforum.com/member.php...o&userid=32945 View this thread: http://www.excelforum.com/showthread...hreadid=552852 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anyone know of a forum like this one that deals with MS Word? | New Users to Excel | |||
How do I develop a forum in Excel? | Excel Discussion (Misc queries) | |||
How to access Excel forum through Outlook Express | Excel Discussion (Misc queries) | |||
Show me how to use the forum | Excel Discussion (Misc queries) |