Solved

Excel "un"-Array formula in range of cells

Posted on 2012-03-20
3
745 Views
Last Modified: 2012-03-21
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
0
Comment
Question by:AndresHernando
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 37741652
That would imply that you are not changing all the cells. When you have selected all of them, and edited the formula, you need to use Ctrl+Enter rather than just Enter to commit the change.
0
 
LVL 7

Expert Comment

by:leptonka
ID: 37741656
Hi,

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/groups/Where-are-my-array-formulas-3843467.S.98906603

Cheers,
Kris
0
 

Author Comment

by:AndresHernando
ID: 37746520
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
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question