sorting an array

  • Thread starter Thread starter lillady718
  • Start date Start date
L

lillady718

I have got to keep track of depleting money through my excel worksheet.
As each "person's" name comes in with monetary amount I put it into my
already formulated cell/rows.

However, after a period of time, I'd like to be able to
alphabetize/sort by the "person's name".........but when I try it will
say "CANNOT CHANGE PART OF AN ARRAY"

I can eventually just alphabetize the names....but then of course the
monetary values are NOT sorted/so incorrect for each name.....

Any help would be greatly appreciated..........thanks
:confused:
 
Look in the cells of the area to be calculated. Do you have a formula
encased in braces {.....}
You cannot sort this because the sort will change each formula one-by-one.
If you find such a formula let us know what it is because for the simple
application you discribe an array formula may be unnecessary.
Bernard
 
It sounds like you have an multicell array formula.

Array formulas are formulas that you hit ctrl-shift-enter (instead of just
enter). You can have an array formula in one cell or multiple cells--you've got
the multiple cell version.

Excel tries to help you find them by wrapping the formulas with curly brackets
{}.

You can find the extent of the range used by the array by selecting one cell,
then hitting F5 (edit|Goto) and clicking Special, then checking the "current
array" option button.

The real question is should it be an array formula. What you do next would
depend on this answer. You may want to post the formula if you need help.

You can read a lot more about array formulas from Chip Pearson's site:
http://www.cpearson.com/excel/array.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top