Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtotal and Names
When I use a name reference to use in lookup functions, the subtotal in the
data sheet is working very slowly. eg:Sheet: sales-sheet, defined name: sales Sheet : MonthSummary (this sheet has a vlookup function using defined name "sales") now if I do a subtotal function to get the month totals in sales-sheet this works very slowly. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Names and Subtotal in office 2003 | Excel Discussion (Misc queries) | |||
Using more than one subtotal with same data set | Excel Worksheet Functions |