T
TexJen
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
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