Excel 2010 help!

[coco200066]

I have two columns of numbers, column A and column B. I need to run a formula that not only shows if any numbers from A show up in B, but also how many times they show up?

Any help woukd be appreciated.

 

[ss202sl]

It's tough doing your own homework isn't it?

 

[Deleted member 904905]

Looks like a class assignment.

 

[DrRiisTab]

I have two columns of numbers, column A and column B. I need to run a formula that not only shows if any numbers from A show up in B, but also how many times they show up?

Any help woukd be appreciated.

Do the numbers in column B appers only once?

 

[Alabalcho]

I am positive I have posted an advice here...
countif( <>, <>) function should help

 

[Deleted member 904905]

I am positive I have posted an advice here...
countif( <>, <>) function should help

You did, but we don't do other's homework for them here.

 

[Alabalcho]

Telling someone "You need to take bus line #23 to get to point X, ask the driver which stop to hop off" is not the same as "Let me drive you to the point X"...

 

[USAFRet]

Telling someone "You need to take bus line #23 to get to point X, ask the driver which stop to hop off" is not the same as "Let me drive you to the point X"...

For a question like this, what should happen is:
From the OP - I'm trying to do X
Here is the code I tried.
And here is some other code I tried.

Where am I going wrong?


Instead of - How do I do X?

What he's asking is pretty easy, and seems to be a simple class assignment.
Simple google search would assist.

But I/we are not going to 'do it' for him.