Increase the numbers in cells with comma-separated and sequence wise using drag functionality in excel

0
votes

I wanna list prepare in excel in which to increase the numbers in cells with comma-separated and sequence wise using drag functionality.

I have used CONCATENATE and other formulas but they are not working.

See the image below, when I drag cell with two rows the output is not coming as the desired result

enter image description here

Desired Result

enter image description here

If there any workaround please help me.

Your help is highly appreciated

1
excelexcel-formulasequence
By '1,2', do you mean 1.2 or 1 and 2? - SimpleBinary
@SimpleBinary its comma - 1,2 - Query Master

1 Answers

3
votes

Without further details from where these numbers come from, you could add the following formula to AT2:

=(ROW()-2)*2+1&","&ROW()*2-2

Drag down.