Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2010, 12:35 AM
Learner7 Learner7 is offline How to compare 2 columns with other two columns in EXECL 2007? Windows XP How to compare 2 columns with other two columns in EXECL 2007? Office 2007
Advanced Beginner
How to compare 2 columns with other two columns in EXECL 2007?
 
Join Date: May 2010
Posts: 49
Learner7 is on a distinguished road
Default How to compare 2 columns with other two columns in EXECL 2007?

Hi,

I have four columns in a excel sheet. I would like to compare the data of first two columns (Column 1 & Column 2) with the next two columns (Column 3 & Column 4). After comparing the data, the result (difference) should be shown in Column 5 & Column 6.

Please do help me in this regard.



Thanks in advance.
Reply With Quote
  #2  
Old 06-03-2010, 08:57 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline How to compare 2 columns with other two columns in EXECL 2007? Windows XP How to compare 2 columns with other two columns in EXECL 2007? Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

What kind of data is it, and what kind of result do you expect?
Reply With Quote
  #3  
Old 06-05-2010, 02:05 AM
Learner7 Learner7 is offline How to compare 2 columns with other two columns in EXECL 2007? Windows XP How to compare 2 columns with other two columns in EXECL 2007? Office 2007
Advanced Beginner
How to compare 2 columns with other two columns in EXECL 2007?
 
Join Date: May 2010
Posts: 49
Learner7 is on a distinguished road
Default

Quote:
Originally Posted by ConneXionLost View Post
What kind of data is it, and what kind of result do you expect?
I have text in all four columns. Now, What I need is, whatever the data in 1st & 2nd column available but not in 3rd & 4th column should be shown in 5th & 6th Column.

Regards.
Reply With Quote
  #4  
Old 06-05-2010, 02:05 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline How to compare 2 columns with other two columns in EXECL 2007? Windows XP How to compare 2 columns with other two columns in EXECL 2007? Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Please post a sample spreadsheet.
Reply With Quote
  #5  
Old 06-12-2010, 09:52 AM
Learner7 Learner7 is offline How to compare 2 columns with other two columns in EXECL 2007? Windows XP How to compare 2 columns with other two columns in EXECL 2007? Office 2007
Advanced Beginner
How to compare 2 columns with other two columns in EXECL 2007?
 
Join Date: May 2010
Posts: 49
Learner7 is on a distinguished road
Default

Quote:
Originally Posted by ConneXionLost View Post
Please post a sample spreadsheet.
Please find attached the spread sheet.

Thanks.
Attached Files
File Type: xls My Querry.xls (25.0 KB, 18 views)
Reply With Quote
  #6  
Old 06-12-2010, 09:54 AM
Learner7 Learner7 is offline How to compare 2 columns with other two columns in EXECL 2007? Windows XP How to compare 2 columns with other two columns in EXECL 2007? Office 2007
Advanced Beginner
How to compare 2 columns with other two columns in EXECL 2007?
 
Join Date: May 2010
Posts: 49
Learner7 is on a distinguished road
Default

Quote:
Originally Posted by Learner7 View Post
Please find attached the spread sheet.

Thanks.
Please also see the snapshot of my excel file.
Attached Images
File Type: jpg My Querry.JPG (75.2 KB, 18 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Footnotes and Columns toll_booth Word 0 06-02-2010 01:35 PM
How to compare 2 columns with other two columns in EXECL 2007? Independent columns jdthelen Word 2 09-17-2009 09:34 PM
How to compare 2 columns with other two columns in EXECL 2007? Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
Re Formatting Columns? erikjen Word 0 02-16-2009 12:25 AM
How do i get my text in columns straight and inline in word 2007? terrasaw Word 0 09-03-2008 06:00 AM


All times are GMT -7. The time now is 08:08 AM.


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