Question on finding duplicates between two rows??

**greekCPA** · 01-30-2015, 02:57 PM

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

**wannabacat** · 01-30-2015, 03:59 PM

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

**samba_ravi** · 01-30-2015, 04:17 PM

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

Question on finding duplicates between two rows??

LinkBack

Thread Tools

Rate This Thread

Display

Question on finding duplicates between two rows??

Re: Question on finding duplicates between two rows??

Re: Question on finding duplicates between two rows??

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Finding Duplicates Rows of Data on a daily spreadsheet

Need help finding duplicates between 2 rows.

Finding DUPLICATES or identical ROWS in a worksheet

Finding rows with duplicates in two columns

Question on finding # of rows and move to next row after applying autofilter

Bookmarks

Bookmarks

Posting Permissions