# Sequence

#### April76

##### New Member
Hi,

How can I create a sequence with a formula starting in A1 that will give 1,1,2,2,3,3 and so on horisontally?

Regards

/T

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### njimack

##### Well-known Member
=roundup(column()/2,0)

#### MickG

##### MrExcel MVP
Place a "1" in "A1" and then the formuls below in "B1" , then copy across.
Code:
``=IF(COUNTIF(\$A\$1:A1,A1)=2,A1+1,A1)``

Last edited:

#### Rick Rothstein

##### MrExcel MVP
You can also use this formula...

=INT((1+COLUMN())/2)

Replies
7
Views
203
Replies
1
Views
337
Replies
12
Views
235
Replies
9
Views
115
Replies
8
Views
239

1,195,582
Messages
6,010,578
Members
441,557
Latest member
Jbest23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back