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

[peukpokicuzo]

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

[LookImAHooman]

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)?

[LookImAHooman]

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