View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Is this doable using excel?

Hi
and you want to make sure they're equal?. If yes use
=SUMPRODUCT(--(A1:C1=A2:C2))

--
Regards
Frank Kabel
Frankfurt, Germany


Michael wrote:
Hi again,

I am rewording the case since I don't think I did it before rightly.

Say I have this in an excel sheet:

A B C
3.5 12.4 6.3

I want to compare each cell of one row to another cell in same

column.
So, say I have another row like this:

3.5 7.7 6.3

I want to compare top A with bottom A, top B with bottom B, and so

on.
The answer should look like this:

A B C
3.5 12.4 6.3 2


How can I do this in excel?

Thanks alot,
Mike