Thread: getting a formula to return the reference of a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default getting a formula to return the reference of a cell
=ADDRESS(MATCH(MAX(F$1:F$23719),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 ..
Reply With QuoteReply With Quote