comparing multiple columns

T

teejay

Hello All,

So I have about 7 columns of data that I want to compare with each other and
I want to find unique entries in each column as well as common entries in
more 2 or more than 2 columns.

What is the easiest and fastest method of doing it in excel.

Many thanks in advance
 
Top