| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a more efficient way of performing this calculation?
=INDEX('2008Summary'!$B14:$R14,,MATCH('Calc
Data'!B3,'2008Summary'!$B9:$R9,0)) or =INDEX('2008Summary'!$B9:$R100,6,MATCH('Calc Data'!B3,'2008Summary'!$B9:$R9,0)) where the 6 is the equivalent of the 5 in your offset formula -- Regards, Peo Sjoblom "Dave F" wrote in message ups.com... 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 |
| Reply |
| 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)
Linear Mode
