Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2011, 02:07 PM
ramadevidokkuud ramadevidokkuud is offline Comparing Data - MS Excel Windows XP Comparing Data - MS Excel Office 2007
Novice
Comparing Data - MS Excel
 
Join Date: May 2011
Posts: 1
ramadevidokkuud is on a distinguished road
Unhappy 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?
Reply With Quote
  #2  
Old 05-19-2011, 05:52 AM
OTPM OTPM is offline Comparing Data - MS Excel Windows 7 32bit Comparing Data - MS Excel Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Data - MS Excel 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 Data - MS Excel 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 - MS Excel Comparing Data leroytrolley Excel 1 08-09-2008 08:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft