hi all
i have in cell i.e. I19 the following formula:
=CHOOSE($E$6,TEXT(Calc!I17,"$#,#"),TEXT(Calc!W17,"$#,#"),TEXT(Calc!AK17,"##%"),TEXT(Calc!BM17,"##%"))
essentially, it shows either YTD actual rev, YTD buget, % to plan and YoY growth
i want to show the max in each column, for example in column I (range I19:I25).
when i make the formula =MAX(I19:I25)
-it does not work because of the "text" formula.
is there any way to get the max to work? thanks.
Bookmarks