Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-14-2009, 04:19 PM
kgfendi kgfendi is offline Windows Vista Office 2007
Novice
 
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, 20 views)
Reply With Quote
  #2  
Old 05-15-2009, 08:34 AM
zyzzyva57 zyzzyva57 is offline Windows 7 32bit Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 356
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, 36 views)
Reply With Quote
  #3  
Old 05-15-2009, 05:24 PM
kgfendi kgfendi is offline Windows Vista Office 2007
Novice
 
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 Windows Vista Office 2007
Novice
 
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 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 Windows Vista Office 2007
Novice
 
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
Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM
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
Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM
Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft