| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limitations to 2 variable data tables?
I'm getting an odd result with 2 variable data tables in a complex
spreadsheet - only the 1st (top left) cell returns the proper value, the rest are either zero (or Div/0! errors if I try to return a percentage result). The data table evaluates the result of a very complex formula [resulting from offset(), vlookup() & if() statements]. However, 1 variable data tables work correctly for each of the two variables I want in the 2 variable data table. Can anyone shed any light on this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limitations with Pivot Tables | Excel Worksheet Functions | |||
| MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges | Excel Worksheet Functions | |||
| Dynamic scenarios - more than 2 variable using data tables in Exc | Excel Discussion (Misc queries) | |||
| DATA > TABLE -- 2 variable data tables? | Excel Worksheet Functions | |||
| DATA > TABLE -- 2 variable data tables? | Excel Discussion (Misc queries) | |||
Threaded Mode
