I have (2) rows of data, A1:X1 & A2:X2.
I want to compare A1 to A2, B1 to B2, and so on. Additionally, I want count the sum each time A1 = (A2 - 1).
I know I need to implement an array formula, but I cannot get anything to work. I'm hoping this can be done in one formula.
Any help is greatly appreciated.
Bookmarks