|
|
#1
06-06-2017, 02:54 PM
|
|||
|
|||
Comparing excel sheets
I have two sheets in same workbook. In sheet 1, column 1 contains ID numbers, while sheet 2 contains ID numbers which can also be in sheet 1.
My problem is this: I want excel to go through is row in sheet1 and checked whether the ID number in each cell is also found in Sheet 2 and return with false or true. I am an oldie novice. Somebody help me, pls. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 new to VBA help comparing two sheets
|
mlttkw | Excel Programming | 1 | 04-21-2016 08:32 AM |
| HELP - comparing spreadsheets in excel 2010 | ali212006 | Excel | 1 | 04-03-2014 04:04 AM |
| Comparing two excel worksheets | SaneMan | Excel | 1 | 06-27-2012 07:52 PM |
|
Excel sheets
|
ubns | Excel | 4 | 04-15-2012 10:48 PM |
| Comparing Data - MS Excel | ramadevidokkuud | Excel | 1 | 05-19-2011 05:52 AM |
Windows 10 
Office 2010 32bit
Threaded Mode