Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENETER (not just
ENTER):

="F"&MATCH(LARGE(F1:F23719-ROW(F1:F23719)/10^10,ROWS($1:1)),F1:F23719-ROW(F1:F23719)/10^10,0)

Biff

"CB" wrote in message
...
Still does nto work . I will try a differnt way ..

"Teethless mama" wrote:

Here is the correct formula, the previous one was missing a bracket ")"

=ADDRESS(MATCH(LARGE(F$1:F$23719,ROWS($1:1)),F$1:F $23719,0),1,4)


"CB" wrote:

I find in a one column range the top value with the function
LARGE(F$1:F$23719,1)
How can i find the reference of the cell wher this value is stored?

thasnk you in advance ..