Hi all,

I am trying to create a function that will display and update the highest
total achieved in sales and purchase ledger type spreadsheet

Other deisred values a
Current total (this is fine I use sum etc to achieve)
Lowest Total: (like highest total, this would check and update its own value)
Previous Highest total: a mostly static total

an example can be found at
http://web.aanet.com.au/tafehouse/excel-help/

LJ