Excel wizard needed here...

  • Thread starter Thread starter R Green
  • Start date Start date
R

R Green

Hi folks

I was wondering if someone can help?

I have two columns of data in A & B, some of which have the same data
info... i'd like to be able to spit out on the third column (C) what info is
the same in columns A & B.

How do I go about doing this in Excel 2000?

Thanks in advance!
 
Try putting this formula in column C.

IF(S7=U7,S7,"different")

Or fill in the "" with whatever you want.

Hope this helps!
-Mike
 
hi, you may try something like this in cell C1...

=COUNTIF($A$1:$A$20,B1)

copy down. this will give you a count of all cells in column
duplicated in A. you can get as fancy as you want with this, but i
depends somewhat on your end results desired - which i'm not too sur
of at this point
 
oops, this is what I really meant!

Try putting this formula in column C.

IF(A1=B1,A1,"different")

Or fill in the "" with whatever you want.

Hope this helps!
-Mike
 
Back
Top