Comparing Cells

B

basic

I would like to compare the following and end up with the result on the
bottom. Can anyone help?
Column A Column B
1 3
3 3
2 4
5 5
I am looking for two different formula's to give me the following:

1. How many numbers in column B are an exact match to column A (Same number
& same row) (In this example the answer would be 2)

2. How many numbers in column B are the same as in column A but not in the
correct order (In this example the answer would be 0)
 
M

Mike H

Hi,

The answer to you first question is this

=SUMPRODUCT(--(A1:A4=B1:B4))


I'm afraid I can't understand the second.

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

Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
How to map cells to a reference then copy adjacent ones 4
Macro to add numbers in a text string 5
Look up information on one worksheet and transfer to another 3
comparing 2 columns 6
Excel Concatenate with line breaks but ignore blank cells 3
Comparing different length columns 3
Cross-Referencng numbers between worksheets 3

Top