Hello,
I have a spreasheet whi 26 columns and 100s of row of data. I want to compare data from cell B2 to C2, D2 to E2, F2 to G2, etc.
I can Write a formula like C2-B2, E2-D2, G2-F2 and so forth (12 times to compare 24 sets of columns). Question that I have is there a way i can automate this instead of typing 12 times. I cannot drag the formula to the right as the column will compare b2-c2, then d2-c2 etc.
Any help is highly appreciated.
Thanks for looking.
Bookmarks