Excel wizard needed here...

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!
 
M

Mike

Try putting this formula in column C.

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

Or fill in the "" with whatever you want.

Hope this helps!
-Mike
 
F

firefytr

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create custom labels from an csv file + Need items numerically counted out 0
Need Help with a VBA subroutine 0
comparing sheet to sheet and adding value 1
Word for iOS 1
Relevant user should see only his data 0
Create timeline with event being hyperlinks to documents on drive 1
Embed the same Excel multiple times 0
Cells not updated automatically 3

Top