Excel Fill issue

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
 
E

Eduardo

Hi Dan,
The formula as it is working for me, Be sure you don't have the formula as
follow

=$A$2&","&$C$2&","&Q2
 
D

Dan

Eduardo -- I actually cut and pasted the formula. Are you telling me the Ax
and Bx are changing or just the Cx?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top