Comparing Data

ramadevidokkuud · #1 05-18-2011, 02:07 PM

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?

OTPM · #2 05-19-2011, 05:52 AM

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
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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