Hey everybody,
I have a problem that seems pretty simple but I can't figure out what the issue is.
I have two sheets in my workbook. In one I write all the formulas and the other one is where all the data is located (I called it "Dataset" in this example).
I am trying to calculate the maximum of a given Column from the sheet "Dataset" using this formula "=MAX(OFFSET('Dataset'!A3;0;1;45300;1))".
Let's say I write this formula in cell A1 of my sheet with all the formulas. When I drag down the formula I now want the formula to chance "A3" to "B3" so I can calculate the maximum of all the numbers in Column B of my "Dataset" sheet.
However I can't figure out how to write the formula so that "A3" becomes "B3" when dragging down the formula.
Any help would be greatly appreciated
Edit: I added a small dataset to better show you what I mean.
What I would like to do is use a formula like the one I wrote down in the example attachment but when I drag the formula down I want the column reference to change from A to B meaning that I now want to calculate the MAX of all the values in Column B of "Dataset".
Bookmarks