Functions on an expanding cell range

  • Thread starter dingdongdingding
  • Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand a box 1
Replacing a data range in a nested array function 1
Excel 2013: AutoFilter and SUM() 1
Excel 2013 1
The sum of the same function that is used for a range of cells 2
excel external data range "failed to refresh" 0
Macro to Combine Data from Multiple Sheets with Cell References 4
can't use function 'countif' in named range 9

Top