Forum Discussion

Copper Contributor

Oct 21, 2023

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

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?

Formulas and Functions

Diamond Contributor

Oct 21, 2023

As variant

=DROP(array,,-2)

Jcfeickert
Copper Contributor
Oct 21, 2023
SergeiBaklan I checked. There is no drop function in the formula list.
- HansVogelaar
  MVP
  Oct 21, 2023
  Jcfeickert
  
  DROP is currently only available in Excel in Microsoft 365 (and Excel Online), not in Office 2021 or older versions.
  
  Try
  
  =INDEX(array, 0, 1)
  - Jcfeickert
    Copper Contributor
    Oct 21, 2023
    Good attempt, but it still says I can't alter part of an array.

Resources