# Question on finding duplicates between two rows??

1. ## Question on finding duplicates between two rows??

Hey guys, since I am not too good with Excel. I need some help!!!

I have two columns in a sheet, under Column A, each cell is numbered 1, 2, 3, through 78,500. Under Column C, I have 21 random numbers between 1 and 78,500. So for example, if one of the numbers under Column C is 58, I want (in Column B) to have an "X" right next to the 58 in Column A to indicate it is on both lists. Know what I mean? I'm thinking a formula that I can put into Column B1 and double click to detect all the duplicate numbers between Column A and Column C. HELP!!!

2. ## Re: Question on finding duplicates between two rows??

Can you share the workbook so I/we can see exactly what you are talking about?
- Thanks

3. ## Re: Question on finding duplicates between two rows??

B1=if(isnumber(match(a1,c:c,0)),"x","")
try this and copy towards down

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1