Talk

Advanced search

Google spreadsheets help

(4 Posts)
LookImAHooman Mon 22-May-17 23:11:01

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 smile

peukpokicuzo Mon 22-May-17 23:18:45

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

LookImAHooman Mon 22-May-17 23:37:05

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 Mon 22-May-17 23:39:52

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

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now