I have this formula in D2.
I want to drag this to C2. And I'm expecting that it will become this
See highlighted in Bold
I'm expecting that the D will change to C in the 3rd argument.
Because the range D$13:D$1000 is absolute for rows but relative for columns.
BUT, when I drag it it does not change. I can't see why that is.
Can anybody spot it? Or tell me that my expectation is incorrect please?