Home |
Search |
Today's Posts |
#1
|
|||
|
|||
List function in earlier Excel versions
How can I replicate the Excel 2003 LIST function in an earlier version of
Excel, say 2000? I want to keep subtotals visible at the bottom of the worksheet at all times and to dynamically update when filters change. Although I am not concerned about inserting new rows... Any help is much appreciated. Regards, JC |
#2
|
|||
|
|||
List function in earlier Excel versions
You can't
-- Regards, Peo Sjoblom (No private emails please) "John_Carty" wrote in message ... How can I replicate the Excel 2003 LIST function in an earlier version of Excel, say 2000? I want to keep subtotals visible at the bottom of the worksheet at all times and to dynamically update when filters change. Although I am not concerned about inserting new rows... Any help is much appreciated. Regards, JC |
#3
|
|||
|
|||
List function in earlier Excel versions
I find that difficult to believe since the autofilter capability, subtotal
function, etc. are sill accessible. What about splitting the window to display the bottom of the spreadsheet where the subtotals do exist? "Peo Sjoblom" wrote: You can't -- Regards, Peo Sjoblom (No private emails please) "John_Carty" wrote in message ... How can I replicate the Excel 2003 LIST function in an earlier version of Excel, say 2000? I want to keep subtotals visible at the bottom of the worksheet at all times and to dynamically update when filters change. Although I am not concerned about inserting new rows... Any help is much appreciated. Regards, JC |
#4
|
|||
|
|||
List function in earlier Excel versions
Yes if you split the window you can have subtotals at the bottom visible.
I wouldn't call that replicate though -- Regards, Peo Sjoblom (No private emails please) "John_Carty" wrote in message ... I find that difficult to believe since the autofilter capability, subtotal function, etc. are sill accessible. What about splitting the window to display the bottom of the spreadsheet where the subtotals do exist? "Peo Sjoblom" wrote: You can't -- Regards, Peo Sjoblom (No private emails please) "John_Carty" wrote in message ... How can I replicate the Excel 2003 LIST function in an earlier version of Excel, say 2000? I want to keep subtotals visible at the bottom of the worksheet at all times and to dynamically update when filters change. Although I am not concerned about inserting new rows... Any help is much appreciated. Regards, JC |
#5
|
|||
|
|||
List function in earlier Excel versions
Hi John
I usually insert a row above my header and use =Subtotal(9,range) With Freeze Panes on to keep the headers visible, the totals are also always visible for the complete or filtered ranges. Regards Roger Govier John_Carty wrote: I find that difficult to believe since the autofilter capability, subtotal function, etc. are sill accessible. What about splitting the window to display the bottom of the spreadsheet where the subtotals do exist? "Peo Sjoblom" wrote: You can't -- Regards, Peo Sjoblom (No private emails please) "John_Carty" wrote in message ... How can I replicate the Excel 2003 LIST function in an earlier version of Excel, say 2000? I want to keep subtotals visible at the bottom of the worksheet at all times and to dynamically update when filters change. Although I am not concerned about inserting new rows... Any help is much appreciated. Regards, JC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Excel 2002 compatibility with earlier versions | Excel Discussion (Misc queries) | |||
Lookup function in Excel | Excel Worksheet Functions | |||
In Excel, why sort function fails when applied to a list of date? | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |