September 11, 2021
I Want to copy 250 array formula(reference in different sheet) from horizontal to vertical without changing reference point.
I want only same formula but in vertical not in horizontal.
I don't want to use Transpose function as i want to retain same array formula.
I have replace "=" with "ZZZ" in all pasted vertically(Transpose) & again changed to "ZZZ" to "=" but since it's array formula every cell i don't want to type Ctrl+Shift+Enter.
Please support. I am using MS Excel 2007
July 16, 2010
Welcome to our forum!
Maybe you can change it to a multi-cell array formula. That way you select the cells first, then enter the formula and press CTRL+SHIFT+ENTER. You'll no doubt need to change the cells being referenced too. Hard to say much more without an example file.
October 18, 2018