Q. Check if 2 arrays have the same values in the same order

Question

I have looked at other posts that supposedly have solved this issue, but this method still doesn't work for me. I had run into an error in a larger program I was writing but I narrowed the error to this method.

I set a cell to =isMatch( {1,2,3} , {1,2,3} ) to verify my method works. The cell computes to False, and I don't know why or how to fix it.

Before I checked stackoverflow, I had originally written code identical to the answer of this post.

Here is the code I currently have.

function isMatch(arr1,arr2){//Returns True if same Array values in same location
  if(arr1.length !== arr2.length)
        return false;
    for(var i =0; i<arr1.length; i++) {
        if(arr1[i] !== arr2[i])
            return false;
    }

    return true;
}

Also checkout [this answer](https://stackoverflow.com/a/10316616/) — TheMaster, Apr 25 '20 at 19:50
This `isMatch( {1,2,3} , {1,2,3} )` should be this `isMatch( [1,2,3] , [1,2,3])` — Cooper, Apr 25 '20 at 21:13
@Cooper It's a Google sheets formula array. In sheets, `={1,2}` in formula is `[[1,2]]` and `={1;2}` is `[[1],[2]]`. You can directly type it in sheets to see — TheMaster, Apr 25 '20 at 21:22

TheMaster · Accepted Answer · 2020-04-25T19:42:08.557

You're comparing a 2D array. {1,2,3} === [[1,2,3]] and not [1,2,3].

To compare a n dimensional array, you can recurse:

function isMatch(arr1, arr2) {
  if (typeof arr1 !== typeof arr2)
    throw new TypeError('Arrays or elements not of same type!');
  if (Array.isArray(arr1))
    return (
      arr1.length === arr2.length && arr1.every((e, i) => isMatch(e, arr2[i]))
    );
  return arr1 === arr2;
}

console.info(isMatch([[1], [2]], [[1], [2]]));
console.info(isMatch([[1, 2]], [[1, 2]]));
console.info(isMatch([[1, 2]], 1));

Q. Check if 2 arrays have the same values in the same order

1 Answers1