Cell number of a maximum value

[Guest]

Hi Carlos.
The function ROW needs a range as an argument, e.g. =row
(B14) will return 14 and =row() will return the row of the
cell containing the formula.

To get your number use:
=MATCH(MAX(B1:B10), B1:B10, 0)
This will return the *relative* row within the range. If
your range starts at B1, then it will be identical with
the absolute row number. If you want the absolute row
number and the range is, say, B4:B14, then use
=MATCH(MAX(B4:B14), B4:B14, 0) + 3,
where 3 = 4(the first row) - 1

HTH
Kostis Vezerides

-----Original Message-----
Hi,
I'm trying to have excel display the cell number

(actually I just need the row number) of a maximum in a
range of values. That is, I want a cell whose value
changes if the position of the maximum value in a list
changes.

I've tried =ROW(MAX(B1:B10)) for example but it looks

like these kind of functions don't accept MAX as an
argument.