Farnk,

Thanks alot, your formula did work very well.

Regards,
Mike



"Frank Kabel" wrote in message ...
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