Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-14-2009, 04:19 PM
kgfendi kgfendi is offline Compare data in different columns in an Excel sheet Windows Vista Compare data in different columns in an Excel sheet Office 2007
Novice
Compare data in different columns in an Excel sheet
 
Join Date: May 2009
Posts: 7
kgfendi is on a distinguished road
Default Compare data in different columns in an Excel sheet

Hello,
I am using Excel 2007.


I have some Data need to be analysed.
The problem is, I need to compare some data in a column with other Specific columns. How can I do this? Please find the attached file as an example for this purpose and I will try to explain what I want.

1- I nedd to compare Column (A3 - A23) with (A28 - A48) and (A53 - A73) ....... (A278 - A298). Just want to check if the data (Numbers) on columns A3-A23 are identical to other columns?!
2- Is it possible to compare the same data with other column? for example B28 - B48.

Thanks in advamce for this matter.
Kind Regards
Attached Files
File Type: xls MyData.xls (29.0 KB, 33 views)
Reply With Quote
  #2  
Old 05-15-2009, 08:34 AM
zyzzyva57 zyzzyva57 is offline Compare data in different columns in an Excel sheet Windows 7 32bit Compare data in different columns in an Excel sheet Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

See if this attachment is close to what you want
Attached Files
File Type: xls MyDataaaa.xls (48.5 KB, 47 views)
Reply With Quote
  #3  
Old 05-15-2009, 05:24 PM
kgfendi kgfendi is offline Compare data in different columns in an Excel sheet Windows Vista Compare data in different columns in an Excel sheet Office 2007
Novice
Compare data in different columns in an Excel sheet
 
Join Date: May 2009
Posts: 7
kgfendi is on a distinguished road
Default

HI,
Thank you for your reply.
The solution is only for onr cell, how can append it to include a series of cells?
Kind Regards
Reply With Quote
  #4  
Old 05-15-2009, 05:31 PM
kgfendi kgfendi is offline Compare data in different columns in an Excel sheet Windows Vista Compare data in different columns in an Excel sheet Office 2007
Novice
Compare data in different columns in an Excel sheet
 
Join Date: May 2009
Posts: 7
kgfendi is on a distinguished road
Default

HI again,
I got the solution!!
Many Many thanks!!
Reply With Quote
  #5  
Old 05-16-2009, 05:52 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Compare data in different columns in an Excel sheet Compare data in different columns in an Excel sheet Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Any chance you'd share it so that others searching through the forums could have a solution, too!
Reply With Quote
  #6  
Old 05-16-2009, 05:42 PM
kgfendi kgfendi is offline Compare data in different columns in an Excel sheet Windows Vista Compare data in different columns in an Excel sheet Office 2007
Novice
Compare data in different columns in an Excel sheet
 
Join Date: May 2009
Posts: 7
kgfendi is on a distinguished road
Default

Dear Bird_FAT
Absolutely, Any improvements of the file (Solution) will be shared with others.
Kind Regards
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare data in different columns in an Excel sheet Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM
Compare data in different columns in an Excel sheet compare files rmartin8 Word 1 02-10-2009 10:27 AM
Setting up Analysis Sheet when data does not exist, yet. burnoutdetective Excel 0 10-13-2008 05:57 AM
Compare data in different columns in an Excel sheet Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM
Compare data in different columns in an Excel sheet Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM

Other Forums: Access Forums

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


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