Hi,
i have got the following problem. Cell N5 has a value of 5000 which gives me a row number 5000. I want to find the maximum value of row 5000 to row 5048, and display this max value in G5000 to G5048 as I want to draw this as a horizontal line in a time series chart (48 units).
thanks
Bookmarks