• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

High and Lows of a sum

mally422

New Member
Hello,
I use an excel sheet to record deposits and withdrawals for a bank account. The only formula I use is SUM to show me the current total. Is there a way to have a high (the most money I've had in the account at one time) and a low (the least money I had in the account one time) in separate cells that can always update themselves?

I hope this question makes sense. Thank you for your time.
 
Hi:
Without seeing your data it is difficult to give you a precise solution.

Do you want to find the highs and lows of deposit alone or on the net value(deposit-withdrawal)?

Meanwhile try using the native function "Large" for the most amount
and "Small" for least amount.

Thanks
 
It is possible to calculate a running balance in memory and then use MAX and MIN to identify the extremes. The named formula 'Balance'
= B_Fwd
+ SUMIF( Transaction, "<="&Transaction, Credit )
- SUMIF( Transaction, "<="&Transaction, Debit )

would allow worksheets formulas
= MAX(Balance)
= MIN(Balance)

to provide the bounds. Then again, why not use a helper column showing the running totals and work with that?
 

Attachments

  • Balance (PB).xls
    32.5 KB · Views: 5
Back
Top