Is this doable using excel?
 

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

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

Is this doable using excel?
 

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