Andy
New member
Hi,
I am using Excel 2011 for Mac.
I am trying to sequence two columns; one with some set text and a start number; the other with a number.
I cannot work out how to sequence a block of the SAME number.
So, I have 6 rows of "Claire and David 002" in column A; in column C is the number "5595" for the same 6 rows
I want to then make the next 6 rows "Claire and David 003" in column A and column C has 6 rows of "5596"
Then it would be 6 rows of "Claire and David 004" in column A and column C has 6 rows of "5597"
and so on.
I have attached a screen grab. So, I need to sequence the blocks so they appear as the first block of 6 ("Claire and David 001").
Up until now I can create the first line by simple sequencing and then I copy the first line beneath in both columns and then pull both column A, B & C down to complete the block (of 6 in this case). But I have to do this for every block and when there are 1000 it takes so long!
I am assuming that a solution would mean that the number of rows can be 'x' and the sequencing can go up by jumps of 'y' if necessary? Sometimes the sequence can jump up in 2s or 3s etc.
Thanks for any help!
Andy
I am using Excel 2011 for Mac.
I am trying to sequence two columns; one with some set text and a start number; the other with a number.
I cannot work out how to sequence a block of the SAME number.
So, I have 6 rows of "Claire and David 002" in column A; in column C is the number "5595" for the same 6 rows
I want to then make the next 6 rows "Claire and David 003" in column A and column C has 6 rows of "5596"
Then it would be 6 rows of "Claire and David 004" in column A and column C has 6 rows of "5597"
and so on.
I have attached a screen grab. So, I need to sequence the blocks so they appear as the first block of 6 ("Claire and David 001").
Up until now I can create the first line by simple sequencing and then I copy the first line beneath in both columns and then pull both column A, B & C down to complete the block (of 6 in this case). But I have to do this for every block and when there are 1000 it takes so long!
I am assuming that a solution would mean that the number of rows can be 'x' and the sequencing can go up by jumps of 'y' if necessary? Sometimes the sequence can jump up in 2s or 3s etc.
Thanks for any help!
Andy