Is this doable using excel?

[Michael]

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

 

[Frank Kabel]

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

 

[Michael]

Farnk,

Thanks alot, your formula did work very well.

Regards,
Mike