Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Issues with my excel formula as it needs Circular reference - hlp
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Issues with my excel formula as it needs Circular reference - hlp
im_not_excelling wrote: 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 LJ Hi LJ Take a look at =MAX() and =MIN() Regards Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting rid of a circular reference error message | Excel Discussion (Misc queries) | |||
goal seek circular reference | Excel Discussion (Misc queries) | |||
circular reference (Excel 2000) | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions |