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.

Looking for duplicate numbers from one column
How to duplicate a google doc - Guide
Excel copy column from one sheet to another automatically - Guide
Display two columns in data validation list but return only one - Guide
How to stop itunes from duplicating songs - Guide
How to avoid duplicate records in sql select query - Guide

2 responses

Answer 1 / 2

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

ruth
Mar 31, 2011 at 11:13 AM

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!!!"

CocoJo 67
Apr 3, 2011 at 04:13 AM

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

Answer 2 / 2

Donny
Feb 17, 2010 at 09:29 PM

Worked a treat. Thank you.

Similar discussions

VBA find column by name and sort

Auto generate serial number in excel based on Column

Copy row and insert n times

Converting rows of data in notepad to columns

How to copy the Column value into Rows

Similar discussions

Subscribe To Our Newsletter!