Easier way for a serie

%3CLINGO-SUB%20id%3D%22lingo-sub-1451117%22%20slang%3D%22en-US%22%3EEasier%20way%20for%20a%20serie%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1451117%22%20slang%3D%22en-US%22%3EGood%20afternoon%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20looking%20for%20a%20way%20%2F%20formula%20with%20which%20I%20can%20implement%20the%20following%20series%20in%20A%20column%20in%20Excel%3A%201.1%2C%201.2%2C%201.3%2C%201.4%2C%201.5%2C%201.6%2C%202.1%2C%202.2%2C%202.3%2C%202.4%2C%202.5%2C%202.6%2C%20etc%20...%3CBR%20%2F%3EThis%20is%20necessary%20for%20250%20participants%2C%20with%206%20rows%20each.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20an%20easier%20way%20than%20manually%20pulling%20each%20digit%20up%20to%206%3F%3CBR%20%2F%3EThanks%20in%20advance!!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1451117%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1451234%22%20slang%3D%22en-US%22%3ERe%3A%20Easier%20way%20for%20a%20serie%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1451234%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F694061%22%20target%3D%22_blank%22%3E%40LvW99%3C%2FA%3E%26nbsp%3BIf%20you're%20in%20for%20a%20quick%20and%20dirty%20solution%2C%20please%20have%20a%20look%20at%20the%20attached%20file%20column%20D.%20It%20contains%20a%20sequence%20from%201.1%20to%20250.6%2C%20in%20groups%20of%206.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1453131%22%20slang%3D%22en-US%22%3ERe%3A%20Easier%20way%20for%20a%20serie%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Good afternoon,

I am looking for a way / formula with which I can implement the following series in A column in Excel: 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, etc ...
This is necessary for 250 participants, with 6 rows each.

Is there an easier way than manually pulling each digit up to 6?
Thanks in advance!!
2 Replies
Highlighted

@LvW99 If you're in for a quick and dirty solution, please have a look at the attached file column D. It contains a sequence from 1.1 to 250.6, in groups of 6.

 

Highlighted

@Riny_van_Eekelen Thank you!!!