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

MyData.xls (29.0 KB, 35 views)

See if this attachment is close to what you want

Attached Files

MyDataaaa.xls (48.5 KB, 50 views)

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

HI again,
I got the solution!!
Many Many thanks!!

Any chance you'd share it so that others searching through the forums could have a solution, too!

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