comparing data sets

[Kathleen Clark]

Hi,

I'm a bit new to Excel and the filter options availible. I have two
sets of data that I would like to compare and see which cells are the
same. can I use excell to do this, and if so how?

Thanks!

 

[JE McGimpsey]

I'm a bit new to Excel and the filter options availible. I have two
sets of data that I would like to compare and see which cells are the
same. can I use excell to do this, and if so how?

Assume your lists are in A1:A100 and B1:B100. You can identify items
that exist in both lists by entering

C1: =IF(COUNTIF($A$1:$A$100,B1)>0,"Same","")

and copy down to C100. You can then filter on column C.

If the position needs to be the same, enter

C1: =IF(A1=B1,"Same","")

and copy down.

For more options, see

http://cpearson.com/excel/duplicat.htm