=ADDRESS(MATCH(MAX(F4:F16),F4:F16,0)+ROW(F4)-1,COLUMN(F4:F16))

and

=ADDRESS(MATCH(MIN(IF(F4:F16<0,F4:F16)),F4:F16,0) +ROW(F4)-1,COLUMN(F4:F16))

the second formula is an array formula, it should be committed with
Ctrl-Shift-Enter, not just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jezzica85" wrote in message
...
Hi all,
I know there's a way to find the maximum and minimum values in a range of
cells, but is there a way to return the cell references those values
occupy
instead of the actual values, and ignoring zeros/blank cells in the
minimum?
Thanks!