It should give you the last one ... no?<g
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Biff" wrote in message
...
What happens when there are duplicate Max's or Min's?
<g
Biff
"Ragdyer" wrote in message
...
Try this *array* formula:
=ADDRESS(MAX((A1:Y31=MAX(A1:Y31))*ROW(A1:Y31)),MAX ((A1:Y31=MAX(A1:Y31))*COLU
MN(A1:Y31)))
--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter,
instead
of
the regular <Enter, which will *automatically* enclose the formula in
curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"Michael Turnbeaugh" <Michael
wrote
in
message ...
When looking at a range of cells, I need both the contents of the
maximum
value in the range and the actual cell address of that cell. For
example,
I
have a series of readings from A1 to Y31 to represent every hour and
day
of a
month. If the highest reading is in the 11th hour of the 15th day
(obtained
by the function MAX(A1:Z31) then i need to be able to get the actual
address
of K15 returned also. This is used for billing purposes.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...et.f unctions