Looking for duplicate numbers from one column

Solved/Closed
Donny - Feb 17, 2010 at 01:10 PM
rizvisa1
Posts
4479
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 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
1
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"
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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!!!"
0
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 3, 2011 at 05:30 AM
May be if you post some sample data one can see what can be done
0
Worked a treat. Thank you.
0