View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_27_] Michael[_27_] is offline
external usenet poster
 
Posts: 41
Default 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