D
Dan
Excel 2007
When I fill down the following formula
=A2&","&C2&","&Q2
I get
=A2&","&C2&","&Q3
=A2&","&C2&","&Q4
=A2&","&C2&","&Q5
=A2&","&C2&","&Q6
=A2&","&C2&","&Q7
Instead of what I wanted
=A3&","&C3&","&Q3
=A4&","&C4&","&Q4
=A5&","&C5&","&Q5
=A6&","&C6&","&Q6
=A7&","&C7&","&Q7
When I fill down the following formula
=A2&","&C2&","&Q2
I get
=A2&","&C2&","&Q3
=A2&","&C2&","&Q4
=A2&","&C2&","&Q5
=A2&","&C2&","&Q6
=A2&","&C2&","&Q7
Instead of what I wanted
=A3&","&C3&","&Q3
=A4&","&C4&","&Q4
=A5&","&C5&","&Q5
=A6&","&C6&","&Q6
=A7&","&C7&","&Q7