I currently calculate the beginning and end data rows for each Division. Three divisions and the size of data changes monthly.
So I calculate for Division 1 (using MATCH), the beginning and end data rows; eg. 2 & 2555. Then I want to use those numbers in a formula without having to to go to formula editor and manually insert them.
"Median FTR Range": DataAll!$AA$2:$AA$2555 I then use the formula =MEDIAN(DataAll!AA2:AA2555)
See attached for more details.
Bookmarks