I have two formulas in two cells that generate a cell address in each.
How do I use the cell address value given in these cells to select a range (in a formula) and then find the highest number in that range?
Example my formulas return the following cell addresses:
E27 & F33
I need the formula to basically say =MAX(E27:F33), but without the manual input - the range in the formula needs to come from the cells with the cell addresses.
Bookmarks