Having trouble with auto populate issue please help

[alex_lawson]

Hi there, I am trying to create an excel sheet which will autopopulate the following...

15-T0001-1
15-T0001-2
15-T0002-1
15-T0002-2
15-T0003-1
15-T0003-2
15-T0004-1
15-T0004-2
15-T0005-1
15-T0005-2
15-T0006-1
15-T0006-2
15-T0007-1
15-T0007-2
15-T0008-1
15-T0008-2
15-T0009-1
15-T0009-2
15-T0010-1
15-T0010-2
15-T0010-1
15-T0010-2

up until numbers such as 15-T0534-1,15-T0534-2,15-T0535-1,15-T0535-2 etc
can anyone PLEASE help me with this?

[Special-K]

There's no consistency.

You have two entries for each T00 line
but T0010 has FOUR entries???

Why has it suddenly changed to four entries?

[Special-K]

Try this

in B1
="15-T00"&RIGHT("0"&INT((ROW()-1)/2)+1,2)&"-"&MOD(ROW(),2)+1
and copy down

NOTE: Check your results around row 19 regarding the above

[alex_lawson]

Hi there, I am trying to create an excel sheet which will autopopulate the following...

15-T0001-1
15-T0001-2
15-T0002-1
15-T0002-2
15-T0003-1
15-T0003-2
15-T0004-1
15-T0004-2
15-T0005-1
15-T0005-2
15-T0006-1
15-T0006-2
15-T0007-1
15-T0007-2
15-T0008-1
15-T0008-2
15-T0009-1
15-T0009-2
15-T0010-1
15-T0010-2
15-T0010-1
15-T0010-2

up until numbers such as 15-T0534-1,15-T0534-2,15-T0535-1,15-T0535-2 etc
can anyone PLEASE help me with this?

Sorry that was an error there should only be two entries per number!

[alex_lawson]

hi there, this is almost there i think, it is generating the following...

15-T0001-1
15-T0002-2
15-T0002-1
15-T0003-2
15-T0003-1
15-T0004-2
15-T0004-1
15-T0005-2
15-T0005-1
15-T0006-2
15-T0006-1
15-T0007-2
15-T0007-1
15-T0008-2
15-T0008-1
15-T0009-2
15-T0009-1
15-T0010-2
15-T0010-1

Any idea how i can get the 1's and 2's in the right order and how to have 15-T0001-2 at the start as it seems to be missing this? Thank you for your help!!