Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DAVERAGE, DMIN,etc from List
Clueless on even if what I'm asking is possible...
I have an Excel worksheet and got the AutoFilter drop-downs, from creating a list. When expand the drop-down, I see: "All", "Top 10", "Custom", the a Listing of the Items in the column... I've got the "Total" row at the bottom, with things like: AVG, Count, Max. I was requested to use DAVERAGE, DMIN, DMAX and DSUM functions. I gather that is because the data in the sheet might change - although I don't understand what the difference is. Most importantly, how can I add the D'functions to this list? Can/should it be added to the "list" drop-down, or can it come from the Total fxns? I've got about 5 columns that are supposed to have each of the D'fxns requested above. Thank you much for any assistance! -TexJen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DAVERAGE, DMIN,etc from List
Search for "Database functions" in Excel Help menu
"TexJen" wrote: Clueless on even if what I'm asking is possible... I have an Excel worksheet and got the AutoFilter drop-downs, from creating a list. When expand the drop-down, I see: "All", "Top 10", "Custom", the a Listing of the Items in the column... I've got the "Total" row at the bottom, with things like: AVG, Count, Max. I was requested to use DAVERAGE, DMIN, DMAX and DSUM functions. I gather that is because the data in the sheet might change - although I don't understand what the difference is. Most importantly, how can I add the D'functions to this list? Can/should it be added to the "list" drop-down, or can it come from the Total fxns? I've got about 5 columns that are supposed to have each of the D'fxns requested above. Thank you much for any assistance! -TexJen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
min, dmin, etc | Excel Worksheet Functions | |||
dmin | Excel Worksheet Functions | |||
DMIN Criteria | Excel Worksheet Functions | |||
MIN or DMIN ? | Excel Worksheet Functions | |||
Function DMIN? | Excel Worksheet Functions |