Thread: [Solved] Compare data in different columns in an Excel sheet
View Single Post
 
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, 33 views)
Reply With Quote