Need to convert text


This formula returns “O7:X7”. I need to use in the formula =RANK(F20,O7:X7). What do I need to do to get my formula to return O7:X7 (without quotes) so it will work in the RANK formula?

INDIRECT(“O7:X7”) converts the address into a reference.

OFFSET(A3;MATCH(EOMONTH(A20;0);A4:A15);14;1;10) returns the same reference.
From A3 MATCH(…) rows down, 14 columns to the right, resized to 1 row, 10 columns.