Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am working with a table in which each cell contains an array equation.
Whenever I need to make a change, it turns into a major hassle. I can drag equations with relative refences, but I loose the array portion of the equation. I then have to go through each cell and hit "shift+ctrl+enter" to turn it back into an array equation. Is there a way I can select all the cells in the table and turn them all into array equations in one swoop? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OFFSET and array formulae | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
What instead of an array formula? | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |