Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing Cells
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing Cells
Hi,
The answer to you first question is this =SUMPRODUCT(--(A1:A4=B1:B4)) I'm afraid I can't understand the second. Mike "basic" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help Comparing Cells | Excel Discussion (Misc queries) | |||
Comparing cells when they are not exactly the same | Excel Discussion (Misc queries) | |||
comparing cells | Excel Discussion (Misc queries) | |||
Comparing Cells | Excel Worksheet Functions | |||
Comparing Cells | Excel Worksheet Functions |