Hi,
I've got some data set out like so:
which I need in the following format:
The ID column is sorted. It increments by 1 every 5 rows, that's no problem. The QID, similar. The FQ2 column is generated by the next FQ1 minus 1, except for the one for QID 4 which is always 9999999. That's sorted too.
The problem comes when I try to autofill the FQ1 and PRICE columns. It seems to jump to the row number that I'm auto-filling rather than increase the row number by one. It's quite tough to describe but easy to see in action if you wouldn't mind taking a look at the attached file.
I've played about with absolute referencing and using INDIRECT and ADDRESS but am getting nowhere. I'm a web designer so don't have a great deal of contact with Excel but can usually get around any problems I've faced. I've tried and tried with this, can't find anything online to help and am bowing to the greater combined knowledge of this forum to give me a hand!
Thanks in advance,
Scott.
Bookmarks