Looking for duplicate numbers from one column

Solved/Closed
Donny - Feb 17, 2010 at 01:10 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 3, 2011 at 05:30 AM
Hello,


i have 4300 old applicant numbers which i need to check against 3300 new applicant numbers and highlight duplicates. these are in two columns next to each other. how can i achieve this in excel,

support is appreciated.

Donny.

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2010 at 01:23 PM
You can try this

If two numbers are in A and B column

Then you can use match. In cell c2 you can write this

=IF(ISERROR(MATCH(B2,A:A,0)), "", MATCH(B2, A:A,0))

It will let you know what row has the same value is found in col A
I know there is an easier forumla than the one you show - i just can't remember what it is - it has to do with "true" "false"
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 31, 2011 at 11:16 AM
Could be Ruth. There is almost always more than one way to to resolve issue. My motto is "what ever works!!!"
Hi Riz Visa 1 - thanks a lot of the help and the formula you posted ! i tried it but it does not work. all i have are word combinations in both columns..... the formula has no errors per se. the problem is that it does not catch any of the words from column b which i am trying to identify in column a.


thanks again or do you have other ideas? cheers
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 3, 2011 at 05:30 AM
May be if you post some sample data one can see what can be done
Worked a treat. Thank you.