AndresHernando
asked on
Excel "un"-Array formula in range of cells
How can I "un'-Array a formula in a range of cells?
Currently, I have a range of cells containing an array formula, and I want to make it a plain formula for all the cells. Is there a way to highlight the range and then "un"-Array the formula in all the cells? Everything I try gives me error message: "You cannot change part of an array".
Thanks, --Andres
Currently, I have a range of cells containing an array formula, and I want to make it a plain formula for all the cells. Is there a way to highlight the range and then "un"-Array the formula in all the cells? Everything I try gives me error message: "You cannot change part of an array".
Thanks, --Andres
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Rory, that's exactly what I needed.
Kris, I couldn't make it work your way, but thanks for replying to my post.
Thanks again, --Andres
Kris, I couldn't make it work your way, but thanks for replying to my post.
Thanks again, --Andres
Here are some methods how can you highlight cells where there are array formulas.
The simplest is Ctrl-G (or F5) Special..>Current array>ok
You need to select the whole array and delete it. After it you can write your plain formula.
http://www.linkedin.com/gr
Cheers,
Kris