Ranking non-consecutive cells

  • Thread starter Thread starter shikamikamoomoo
  • Start date Start date
S

shikamikamoomoo

First off...I'm not sure if rank is the correct term. I have three
columns, B,E,G - each column contains a number, in column A I need it
to input a number based on which of the three columns is greater. If B
is greatest there would be a 1, E greatest = 2, etc. For example: If
column E is the greatest number, then column A would have a 2. If
anyone has any ideas on how to do this or can point me in the right
direction I would appreciate it....Thanks.
 
Try this
=IF(B1=MAX(B1, E1,G1),1,IF(E1=MAX(B1, E1,G1),2,IF(G1=MAX(B1,
E1,G1),3,NA())))

"shikamikamoomoo"
 
shikamikamoomoo <shikamikamoomoo.1s48eb_1121270707.7903@excelforum-
nospam.com> wrote in @excelforum-nospam.com:
First off...I'm not sure if rank is the correct term. I have three
columns, B,E,G - each column contains a number, in column A I need it
to input a number based on which of the three columns is greater. If B
is greatest there would be a 1, E greatest = 2, etc. For example: If
column E is the greatest number, then column A would have a 2. If
anyone has any ideas on how to do this or can point me in the right
direction I would appreciate it....Thanks.
Click to expand...

Put this formula in A1:

=if(match(MAX(B1;E1;G1);B1:G1;0)=1;1;if(match(MAX(B1;E1;G1);B1:G1;0)=
4;2;3))

The functions were translated from Dutch:

vergelijken = match
als = if
max = max

And my standard separator is the semicolon.

I do not have a Dutch/English reference table so I can only hope I did not
err . . .
 
Back
Top