Hi again!

One workaround that we can do is to enter the array formula to the column
next to the data (as in my previous post). Once you get the desired results,
select the whole range of results from the array formula then select from the
menu Edit then Copy then Paste Special then select Value then OK. This
effectively "freezes" the results so you can now delete the first column
containing the original data (i.e. with the MM # format). Note also that the
array formula also is gone; now you can sort the data. :)

Additional note: make back ups of the file first before proceeding in case
the output is not what you've expected.

Hope this helps!
--
Thanks and kind regards


"AnimatorElf" wrote:


Ouch... I can't Sort them in any specific order... tells me I can't
change an array.


--
AnimatorElf
------------------------------------------------------------------------
AnimatorElf's Profile: http://www.excelforum.com/member.php...o&userid=32944
View this thread: http://www.excelforum.com/showthread...hreadid=543181