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
|