Google spreadsheets help

[LookImAHooman]

I have a column with the top row frozen. The lower cells in the column each reflect a monetary value (depleting budget for house project). I want the top cell (e.g. D1) to automatically change to the lowest value in the rest of the column whenever this is updated. So if I have 'Front door and panel)' in row 48 and the budget balance in D48 is 40,000, then I add in 'WC extractor' in row 62 and the budget balance is D62 is then 39,950, I want D1 to automatically pull in the new lower value from D62 because that's the lowest in the column.

Any help? Thanks

=min(range)
Where range is like a2:a432 representing the column you want the lowest value of

Thanks. Off to a good start but it's throwing an error that a circular dependency has been detected. Guessing this is because cells in D pull in the cell above minus C in the new row - so if D62 is to be the lowest value, that's calculated by D61-C62. Do I need to remove that formula to get min to work (so choose which formula is more valuable to me)?

Don't worry! Solved it by using an additional row at the top. Thanks v much again