Comparing Data - MS Excel

		Microsoft Office Forums > Microsoft Excel > Excel
Comparing Data - MS Excel

FAQ

Thread Tools

Display Modes

05-19-2011, 05:52 AM

OTPM

Windows 7 32bit Comparing Data - MS Excel

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:19 PM.