Using MIN function on a column based on the column's number

Assuming your data runs from row 2 downwards.
Put this in cell A1, copy it and paste it across row 1
=IF(ISERROR(MIN(OFFSET(A$2,0,0,COUNT(A2:A20000),1))),"",MIN(OFFSET(A$2,0,0,COUNT(A2:A20000),1)))

Instead of the MIN try using SMALL. If the data is in column G and you want the answer in column H use this formula:

Formula:

Please Login or Register  to view this content.

If this formula is dragged along a row, the result is that the "SMALL" factor is increase incrementally with each change in column. If your data is in column A and your formula is placed in column B then when you copy the formula across the columns the "MINIMUM" or "SMALL" number will increase. The first number returned would be the smallest then increment upward from there.

If your data is in column A then the formula would be:

Formula:

Please Login or Register  to view this content.

I hope this helps you out.