You can get the last column in a range with a formula based on the COLUMN function.
In the example shown, the formula in cell F5 is:
=MIN(COLUMN(data))+COLUMNS(data)-1
where data is a named range for B5:D10
How...

To find the lowest tide on a Monday, given a set of data with many days of high and low tides, you can use an array formula based on the IF and MIN functions. In the example shown, the formula in I6 is:
{=MIN(IF(day=...

To get the minimum value in a data set using multiple criteria (i.e. to get MIN IF), you can use and array formula based on the MIN and IF functions. In the example shown the formula in I6 is:
{=MIN(IF(color=G6,IF(...

To get the next scheduled event from a list of events with dates, you can use an array formula based on the MIN and TODAY functions to find the next date, and INDEX and MATCH to display the event on that date. In the...

To get the minimum value from a set of numbers, use the MIN function.
In the example shown, the formula in cell I6 is:
=MIN(C6:G6)
The MIN function is fully automatic. It accepts one or more arguments, which can be...

To get the position of the nth match (for example, the 2nd matching value, the 3rd matching value, etc.), you can use a formula based on the SMALL function. In the example shown, the formula in G5 is:
=SMALL(IF(list=...

To calculate the minimum difference between two sets of values, ignoring cases where either value is blank, you can use an array formula based on the MIN and IF functions. In the example shown, the formula in F4 is...

You can get the first row (i.e. the starting row number) in a range with a formula based on the ROW function.
In the example shown, the formula in cell F5 is:
=MIN(ROW(data))
where data is a named range for B5:D10...

To calculate the max or min change in a set of data as shown, without using a helper column, you can use an array formula. In the example, the formula in G6 is:
{=MAX(C5:C12-D5:D12)}
Note: this is an array formula...

To calculate the number of days that overlap in two date ranges, you can use basic date arithmetic, together with the the MIN and MAX functions.
In the example shown, the formula in D6 is:
=MAX(MIN(end,C6)-MAX(start,...

To get the last row number in a range, you can use a formula based on the ROW, ROWS, and MIN functions. In the example shown, the formula in cell F5 is:
=MIN(ROW(data))+ROWS(data)-1
where "data" is the named range B5...

You can get the first column (i.e. the starting column number) in a range with a formula based on the COLUMN function.
In the example shown, the formula in cell F5 is:
=MIN(COLUMN(data))
where data is a named range...

To get the smaller, or lesser, of two values, you can use the MIN function. In the example shown, the formula in D5 is:
=MIN(B5,C5)
How this formula works
The MIN function is fully automatic - it returns the...

To calculate gas (MPG) based on odometer readings you can build a table with a few simple formulas. In the example shown, the formulas in E5 and F5 are:
=[@Mileage]-SUM(C4) // E5 calculate mileage
=[@Distance]/[@...

To find the closest match with a lookup value and numeric data, you can use an array formula based the INDEX, MATCH, ABS and MIN functions. In the example shown, the formula in E5 is:
{=INDEX(data,MATCH(MIN(ABS(data-...