Maryann Wood
asked on
Excel - Series of numbers 1, 2, 3, 4, 5 repeat 1, 2, 3, 4, 5 several times.
I know how to use drag feature to grab a series of numbers - like 1, 2, 3, 4, 5 - then drag and get 6, 7, 8, 9...etc.
How can I do an Autofill Feature where I can take 1, 2, 3, 4, 5 - 1, 2, 3, 4, 5 - 1, 2, 3, 4 5....etc.
I know I can copy and paste - but can I do a highlight + drag feature to autofill?
Thank you Experts!
How can I do an Autofill Feature where I can take 1, 2, 3, 4, 5 - 1, 2, 3, 4, 5 - 1, 2, 3, 4 5....etc.
I know I can copy and paste - but can I do a highlight + drag feature to autofill?
Thank you Experts!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
ASKER
This worked - use this formula to populate the fields starting at A2 (A1 should have the number 1 in it):
=IF(A2=5,1,A2+1)
However the numbers are in reverse order
5
4
3
2
1
5
4
3
2
1
want them to be
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5...........thanks.
=IF(A2=5,1,A2+1)
However the numbers are in reverse order
5
4
3
2
1
5
4
3
2
1
want them to be
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5...........thanks.
Change the formula to if(a1=1,5,a1-1). Start a1 with 5
Sorry did not see your whole response from my phone. Use this formula in an adjacent column: =IF(A1=5,1,IF(A1=4,2,IF(A1 =3,3,IF(A1 =2,4,IF(A1 =1,5,"N/A" )))))
Even simpler formula.
Fill in A1 to A5 with 1 to 5 then in A6 put =A1 and then drag that down as far as required. Copy and paste as values.
Using 1a to 5a and then find and replace to remove the "a" will result in text values rather than numbers.
Fill in A1 to A5 with 1 to 5 then in A6 put =A1 and then drag that down as far as required. Copy and paste as values.
Using 1a to 5a and then find and replace to remove the "a" will result in text values rather than numbers.
ASKER
Thanks Rob!
=IF(A2=5,1,A2+1)
You could then highlight all rows in the column where you want to put the pattern including cell A2 and the top and hit ctrl-d to duplicate that formula down the column.