Cell info from =MAX(A1:A999)

[genyue]

I used the formula =MAX(A1:A999)

the returned value is 1.7933
cell A998 contains value 1.7933

What formula can I use to let me know which cell the value was taken from?
Of course, I can go thought the 999 values manually until A998, but there would take a long time.

I'm looking for something like that
=max-cell-info(A1:A999)
return result will be A998

 

[Sachin.Medhe]

Use below code
=MATCH(MAX(A1:A999),A1:A999)

 

[genyue]

Use below code
=MATCH(MAX(A1:A999),A1:A999)

the returned value is 998
how can I get the returned value as A998?

 

[Sachin.Medhe]

=char(column(a1:a999)+64)&match(max(a1:a999),a1:a999)

 

[Aladin Akyurek]

I used the formula =MAX(A1:A999)

the returned value is 1.7933
cell A998 contains value 1.7933

What formula can I use to let me know which cell the value was taken from?
Of course, I can go thought the 999 values manually until A998, but there would take a long time.

I'm looking for something like that
=max-cell-info(A1:A999)
return result will be A998

Consider...

Item	Max
20	20
15	Count
16	3
20	Address List
12	$A$2
20	$A$5
	$A$7

<colgroup><col style="width: 68pt; mso-width-source: userset; mso-width-alt: 3242;" width="91"> <col style="width: 66pt; mso-width-source: userset; mso-width-alt: 3128;" width="88"> <tbody>
</tbody>

B2, just enter:

=MAX(A2:A7)

B4, just enter:

=COUNTIF(A2:A7,B2)

B6, control+shift+enter, not just enter, and copy down:

=IF(ROWS($B$6:B6)<=$B$4,CELL("address",INDEX($A$2:$A$7,
  SMALL(IF($A$2:$A$7=$B$2,ROW($A$2:$A$7)-ROW($A$2)+1),
  ROWS($B$6:B6)))),"")

 

[Peter_SSs]

I used the formula =MAX(A1:A999)

the returned value is 1.7933
cell A998 contains value 1.7933

What formula can I use to let me know which cell the value was taken from?

When running your MAX formula, can you be certain there will not be more than one cell in the range containing that MAX value?
What do you want to happen if there is more than one cell containing the maximum value?

Edit: Ah, I see Aladin has offered at least one alternative for that scenario.

 

[genyue]

I got my answers.

Thank you Sachin and Aladin so very very much for the answers.