| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a more efficient way of performing this calculation?
Is there a more efficient/concise method for the following: =B8-
OFFSET(INDIRECT(CELL("address",INDEX('2008Summary' ! $B9:$R9,,MATCH('Calc Data'!B3,'2008Summary'!$B9:$R9,0)))),5,) ??? Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF and VLOOKUP - how efficient? | Excel Worksheet Functions | |||
| What is more efficient | Excel Discussion (Misc queries) | |||
| more efficient way to lookup a range? | Excel Discussion (Misc queries) | |||
| Converting to an efficient set of tables | Excel Discussion (Misc queries) | |||
| is there a more efficient formula than... | Excel Worksheet Functions | |||
![Dave F[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
