Excel- Comparing multiple columns

Closed
NS - Oct 1, 2010 at 12:04 PM
Vince.$tone12 Posts 77 Registration date Saturday October 2, 2010 Status Member Last seen October 31, 2010 - Oct 2, 2010 at 09:36 AM
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


Related:

1 response

Vince.$tone12 Posts 77 Registration date Saturday October 2, 2010 Status Member Last seen October 31, 2010 5
Oct 2, 2010 at 09:36 AM
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
0