getting a formula to return the reference of a cell
I get a " errro in formula"
"Teethless mama" wrote:
=ADDRESS(MATCH(LARGE(F$1:F$23719,ROWS($1:1),F$1:F$ 23719,0),1,4)
Copy down to as far as needed
"CB" wrote:
Great but When i cointue down and do the top ten,I get two values that are
the same (my top 10 songs , and how many records they sell , two of them
sold 53 this week ) . so I cannot use the match fuction which returns only
the match for the first occurence.
I was hoping to use the adress fuctiondirectly within the large function to
avoid the problem
"Teethless mama" wrote:
=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 ..
|