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
|