Signalling differences between 2 arrays

**tays01s** · 05-23-2013, 10:21 AM

I have 2 large (col 1500 x row 180) arrays. Each col = a product. Product compositions change so cells in my updated array change colour if the original data in the array below is different. Because the array is so large I might miss a difference that is 'off screen', so I'd like the top row to change colour if ANY cell the rows beneath is different.

1 solution is to have a 3rd array when any cell to cell difference = 1 and so a sum()>0 would trigger a warning that somewhere there was > 1 difference.

Is there a neater solution? Eg. I'd wondered about using if(or(...... but that would be tedious task + I'm not sure if there's a limit to how many OR's are permitted.

**zumbalj** · 05-24-2013, 07:28 AM

At the top of the array, you could sum the absolute values of each array and subtract. Then have it change color if the result is greater than zero, which would signal a change.