#1
|
|||
|
|||
Comparing Data - MS Excel
Hello
I've got two separate worksheets as given bellow, I need to be able to compare the two columns and get result in sheet3 as given bellow. Sheet 1: Colum 1 AA BB CC DD EE FF GG HH II JJ Sheet 2: Colum 1 AA CC FF GG II But i want Sheet 3: BB DD EE HH JJ Can this be done? |
#2
|
|||
|
|||
Hi
Try this formula: =IF(ISNA(MATCH(Sheet1!A1,Sheet2!A:A,0)),Sheet1!A1, "") You will then need to filter your Sheet 3 column A for non-blank cells. Hope this helps. Tony |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
comparing values from a range | struct | Excel | 1 | 04-01-2011 07:17 PM |
help me to manipulate excel data | ibor | Excel | 2 | 02-01-2011 03:14 AM |
Comparing Word Documents | NepalKat#1 | Word | 1 | 01-09-2010 11:18 AM |
macro for comparing data from 3 columns and pasting into another worksheet | ashukla | Excel | 1 | 06-24-2009 05:01 PM |
Comparing Data | leroytrolley | Excel | 1 | 08-09-2008 08:34 PM |