Thread: Comparing Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
basic basic is offline
external usenet poster
 
Posts: 23
Default 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)