Excel- Comparing multiple columns

Closed
Report
-
Posts
76
Registration date
Saturday October 2, 2010
Status
Member
Last seen
October 31, 2010
-
Hello,

I have 8 columns to be compared with each other. Every column is suppose to be compared with every other column . Objective is to identify the items present in one and absent in the other and vice versa .

Is there any simple way to do it ?

Thanks
NS


1 reply

Posts
76
Registration date
Saturday October 2, 2010
Status
Member
Last seen
October 31, 2010
5
Comparing cells will be far ever easy through the Kioskea FAQ solution that is provided below. It is easy to use and find all sorts solved problems from the FAQ section.

https://ccm.net/faq/6232-excel-comparing-cells-across-multiple-columns

Cheers friend