Thread: getting a formula to return the reference of a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default getting a formula to return the reference of a cell
One way:

="F"&MATCH(MAX(F1:F23719),F1:F23719,0)

Biff

"CB" wrote in message
...
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 ..


Reply With QuoteReply With Quote