How do I edit an array on Excel without having to start over?

Question

I have a 3X3 array and I'm trying to take away two columns which are simply copies of the first. How do I do it?

sergeibaklan · Answer

Jcfeickert&nbsp;
As variant
=DROP(array,,-2)

jcfeickert · Answer

SergeiBaklan&nbsp;I checked. There is no drop function in the formula list.

hansvogelaar · Answer

Jcfeickert&nbsp;
DROP is currently only available in Excel in Microsoft 365 (and Excel Online), not in Office 2021 or older versions.
Try
&nbsp;
=INDEX(array, 0, 1)

jcfeickert · Answer

Good attempt, but it still says I can't alter part of an array.

hansvogelaar · Answer

Jcfeickert&nbsp;
Oh, you're trying to delete part of the result of an array formula. As the error message says, you cannot do that. The replies by SergeiBaklan and me assumed that you wanted to return a single column to another range.
You'll either have to change the formula so that it returns only one column, or copy the result range and paste it as values. You can then delete two of the columns since there is no formula anymore.

Forum Discussion

How do I edit an array on Excel without having to start over?

Share

Resources