D
dingdongdingding
I want to do a min() & max() on a range of cells, eg
Nov 2 50.0
Nov 3 55.1
Nov 4 49.0
etc
etc
However, as the dates increases, my range in the function would be
outdated. How to I cater for the expanding range without having to
update the function every day and without having to cater for an large
range of dates in advanced ? Is it possible ? Thanks.
Nov 2 50.0
Nov 3 55.1
Nov 4 49.0
etc
etc
However, as the dates increases, my range in the function would be
outdated. How to I cater for the expanding range without having to
update the function every day and without having to cater for an large
range of dates in advanced ? Is it possible ? Thanks.