Previous Topic Next Topic

Looking for duplicate numbers from one column

[Solved/Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
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

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
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
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Report

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"
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
Could be Ruth. There is almost always more than one way to to resolve issue. My motto is "what ever works!!!"
Report

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
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
May be if you post some sample data one can see what can be done
Answer 2 / 2

Worked a treat. Thank you.
Ask a question