I have a formula below which works as i want it to.
When I drag the formula down i want the row to stay the same and the column to change, but the reverse happens.
I’ve looked into this and I just don’t understand the answers i’m getting. If anyone could edit the formula so that i understand that would be great!
So essentially what would work for me is if all the B’s in the above changed to C’s in the next row, and then D’s in the next…