The times when you had to put numbers in sequence in Excel manually are long gone. In modern Excel, you can make a simple number series in a flash with the Auto Fill feature. If you have a more specific task in mind, then use the SEQUENCE function, which is specially designed for this purpose. Continue reading
Comments on: Excel SEQUENCE function - create a number series automatically
by Svetlana Cheusheva, updated on
Comments page 3. Total comments: 286
1 9 17 25
2 10 18 26
3 11 19 27
4 12 20 28
5 13 21 29
6 14 22 30
7 15 23 31
8 16 24 32
33 41 49 57
34 42 50 58
35 43 51 59
36 44 52 60
37 45 53 61
38 46 54 62
39 47 55 63
40 48 56 64
-- how to create this sequence.. please help me ?
Hello!
Write in the first row 4 numbers - 1 9 17 25.
In cell A2 write the formula =A1+1
Copy this formula 3 columns to the right and 6 rows down.
In cell A9, write the formula =A1+32
Copy this formula 3 columns to the right and down as needed.
Here is the article that may be helpful to you: How to use AutoFill in Excel - all fill handle options.
I am trying to create a spreadsheet to help me keep track of our pay periods and check date.
Imagine this is a spread sheet..lol:
Header: Week Period Begins Period Ends Check Date
1 12/19/21 01/01/21 01/08/21
2 01/02/21 01/15/21 01/22/21
3 01/16/21 01/29/21 02/05/21
4 01/30/21 02/12/21 02/19/21
I made this with my phone side ways.
I am a nube when it comes to formulas, but I try.
Can you help me? Ty!!
Todd Hurley
Hello!
What result do you want to get exactly?
A simple spreadsheet to keep track of bi-weekly pay periods every fiscal year. So at the beginning of every new year I enter the starting dates for period begins, period ends, and Check Date. The cells below each start date automatically configured with a formula for the remaining pay periods for the remaining year. If that makes sense.
Also each pay period header increase by 2 weeks/14 days.
Hi!
If I understand you correctly, write down the date 19.12.21 in cell B1. Try to enter the following formula in cell B2 and then copy it down along the column:
=B1+14
Do the same with columns C and D.
It worked!
Thank you very much for your help!! Much appreciated.
Hi!?
I created a Payroll Spread calculation hours per day x pay per hour to get total gross weekly pay.
I did:
Row M is the daily total gross pay:
M3 = $139.88 + M4= $133.13
=SUM(M3:M4) which should equal
$273.01
How ever the cell shows: $273.00
I made certain to format the cell to currency with 2 decimal places but the .01 is missing. I am a newbie to excel or OpenOffice.
What am I missing? Thank you for your time.?
Todd
Hello!
If your numbers are derived from calculations, then in cells M3 and M4 they are displayed with rounding to two decimal places. However, the number is not rounded. For example, 139.884356 is displayed as 139.88
When adding such numbers, the result is different from what you see in the cells.
To avoid this, use round numbers to 2 decimal places in your formulas.
Hi there
Is there a way to combine SEQUENCE and MAX functions? I would like to use SEQUENCE to have a series of descending numbers but don't want the negative numbers in the sequence (i.e. once the descending SEQUENCE goes below zero) as it affects my other SUM functions. I tried combining SEQUENCE and MAX functions in an attempt to remedy this but wasn't having much luck combining the two!
I am trying to examine the effect of different reduction rates vs time, attempt was:
=MAX(0,(SEQUENCE(24,1,B1-C1))
Where, B1 = Starting Number C1= Reduction Rate
Thanks in advance
Hello!
Write an example of a sequence of values that you want to get.
e.g.
Starting Point = x = 20
Time = 24 months
Reduction Rate = (x-y), where y ranges between y = 2.8 per month
Would like SEQUENCE to decrease from 20 until it reaches zero and then stop, not continue until the sequence covers the full 24 months.
Hello!
If I understand your task correctly, you can create a sequence using the IF function.
A1 - 20
A2 - =IF(A1-2.8>0,A1-2.8,0)
After that you can copy this formula down along the column.
A pot can hold 1000 coins. I would like to display this as a primary key. For example,
P1C1
P1C2
P1C3
...
P1C999
P1C1000
P2C1
P2C2
...
P2C998
P2C999
P2C1000
P3C1
P3C2
P3C4
The list should have no bottom limit, allowing as many entries as possible.
What is the best way to do this?
Any help would be greatly appreciated!
Hi!
If I got you right, the formula below will help you with your task:
="P"&CEILING(SEQUENCE(4500,1,1,1)/1000,1)& "C" &TRUNC(MOD((SEQUENCE(4500,1,1,1)-1)/1,1000)+1)
what would be the best formula to get gaps on this sequence
220-0007
220-0009
221-0001
223-0001
223-0002
223-0004
to return the exact missing numbers
i.e 220-0008 & 223-0003 are missing.
what would be the best formula to get gaps on this sequence
220-0007
220-0009
221-0001
223-0001
223-0002
223-0004
to return the exact missing numbers
i.e 220-0008 & 223-0003 are missing.
Hello!
Write in another table the sequence that you think is correct. Then compare these columns using the Compare Tables tool.
There is no pattern in your data, so I cannot suggest a formula.
Hello Sir,
Thanks for your help in advance. Every time a record is added to excel I have to generate a sequence number automatically. Sequence=Stage.Phase.Next Number - Can you please help how to do this in excel.
Stage Phase Sequence
1 1 1.1.1
1 1 1.1.2
1 2 1.2.1
2 2 2.2.1
2 3 2.3.1
2 3 2.3.2
Hi!
I don't see any pattern in your data. If it exists, please describe it.
Pattern is Stage.Phase.Next Incremental number in that Stage.Phase
Stage.......Phase.......Sequence
1000...........1..............1000.1.1
1000...........1..............1000.1.2
1000...........1..............1000.1.3
2000...........2..............2000.2.1
2000...........2..............2000.2.2
1000...........2..............1000.2.1
1000...........2..............1000.2.2
Hope it makes sense...thank you!
I did it successfully using COUNTIF. Thank you for your time!
I was searching Google for a better way to do the following and your website popped up. I hope you can help and that it’s not something that can’t be done.
I have a workbook for each month with either 28,30 or 31 tabs/sheets – one for each day depending on the month.
I have a date field in the same cell (E1) for each tab - date format is dd-mmm-yyyy.
I would like the same formula for cell E1 in each tab that increments the date without me having to edit the formula in cell E1 in each tab to change the tab name (Method 1) or increment number (Method 2) to point to the previous tab and add the increment number.
I have the following 2 formulae that works but I have to change each tab (from tab ‘02’ onwards) to either point to the previous tab name and add 1 or add an increasing increment number to tab name ‘01’. Is there a way to specify the previous tab without having to actually name it – ie. is there a variable name that represents the previous tab ? Here is what currently works, but to me is a bit clumsy.
Thanks, in advance, for any suggestions.
Method 1
Tab Name Cell E1
======== ==========
01 01-Jan-2022
02 =('01'!E1+1)
03 =('02'!E1+1)
04 =('03'!E1+1)
05 =('04'!E1+1)
etc etc
Method 2 - it also works if I do this :
Tab Name Cell E1
======== ===========
01 01-Jan-2022
02 =('01'!E1+1)
03 =('01'!E1+2)
04 =('01'!E1+3)
05 =('01'!E1+4)
etc etc
Method 1
Tab Name . . . . Cell E1
======== . . . . ===========
01 . . . . . . . . 01-Jan-2022
02 . . . . . . . . =('01'!E1+1)
03 . . . . . . . . =('02'!E1+1)
04 . . . . . . . . =('03'!E1+1)
05 . . . . . . . . =('04'!E1+1)
etc . . . . . . . . etc
Method 2 - it also works if I do this :
Tab Name . . . . Cell E1
======== . . . . ===========
01 . . . . . . . . 01-Jan-2022
02 . . . . . . . . =('01'!E1+1)
03 . . . . . . . . =('01'!E1+2)
04 . . . . . . . . =('01'!E1+3)
05 . . . . . . . . =('01'!E1+4)
etc . . . . . . . . etc
Hello!
You can only get the name of the previous worksheet using a VBA macro. Regular Excel formulas can only get the name of the sheet where the cell is located:
=MID(CELL("filename",Sheet1!A2),SEARCH("]",CELL("filename",Sheet1!A2))+1,31)
Hi, is it possible to arrange the sequence formula to add number until the end of the table and automatically add a number if the table row range is extended?
Hello!
In the first argument of the SEQUENCE function, you can use the COUNTA function, which will count the number of rows with data in the table. When adding. data in column A, the SEQUENCE function will add one more value.
=SEQUENCE(COUNTA(A:A),1,1,1)
I hope my advice will help you solve your task.
I am attempting to create a series of mobile numbers. The first four digits and final two digits should not change.
Example:
567-000-042
567-000-142
567-000-242
567-000-343
The series should create a list of all possible combinations from 567-000-042 to 567-999-942 (only the 4th-7th digits will change. The first 3 digits and final two digits should not change.) Thank you.
Hello!
Use the TEXT function to write the number in the desired format.
="567-"&TEXT(CEILING(SEQUENCE(1000,1,0,1),1),"000-0")&"42"
I hope my advice will help you solve your task.
Hi there,
I need to create a sequential list of barcode numbes - 20 digits, the first two digits being "00"
What do i need to do to the formula to make that come out, without getting rid of the two "00" at the front of the number
Hello!
To have a number start with "00", save number as text. You can use the & operator to do this:
"00" & 123456
I hope it’ll be helpful.
HELLO SIR
EMP ID Generate :- NAME WITH NUMBER
PRAKASH P0001
PRATIK P0002
POOJA P0003
I don't know how I can.
Hi!
Pay attention to this comment.
I hope it’ll be helpful.
Hello,
I have a question regarding the "n" in the SEQUENCE Function.
Can it be unknown?
From a table, I would like the formula to list all the data that are above 13%. I can do this using the INDEX, SORT and FILTER functions. But I do not know how many people will be above 13%. Is there a solution to this?
My formula is as per the below:
=INDEX(SORT(FILTER(Master!F4:AC248,Master!AC4:AC248>=13%),24,-1),SEQUENCE(20),{1,24})
Thanks,
Matt
Hello!
In the SEQUENCE function, specify the maximum number of values (for example, 245). To ignore errors, use the IFERROR function.
=IFERROR(INDEX(SORT(FILTER(Master!F4:AC248,Master!AC4:AC248>=13%),24,-1),SEQUENCE(245),{1,24}),"")
Hope this is what you need.
Hi Alexander,
Thank you for taking the time to reply and apologies for the delay of my answer.
Unfortunately this does not work for me so had to change the formula to the below:
=INDEX(SORT(FILTER(Master!B4:AC243,(Master!S4:S243="GBP")*(Master!M4:M243=""),"No results"),28,-1),SEQUENCE(20),{5,28})
So what this does is giving me the 20 top percentages. But only 8 of them are above 13%.
How can I make sure that with this formula, it removes the percentages that are under 13%?
(if this is possible).
Thanks,
Matt
Hello
I would like to have this numbering sequence:
01-G
02-G
03-G
Thanks in advance for the help
Hello!
You can use this formula:
=TEXT(SEQUENCE(10,1,1,1),"00")&"-G"
Add text to the sequence of numbers using the & operator.
Hello, I am trying to make a SEQUENCE based on the text in the cell next to it.
Column B can be either IC, IG, IB, or any other 2 letter
Column C is a number list 21001 21002 21003 and so on.
However the number can repeat based on the letters in Column B. So I need the sequence to be based on the next available number that relates to the letters in column B.
I hope that make sense
Hello!
To make a sequence of numbers with a condition, use the formula
=21000+COUNTIF($B$2:B2,B2)
Hope I understood the problem correctly.
It did work thank you. Now if I can get my co workers to stop skipping number
Hello I had a follow up on this. I changed the formula a little to exclude texts from the count so it looks like this now.
=21000+COUNTIFS('2022'!$D$3:D3,D3,'2022'!$K$3:K3,"CO",'2022'!$K$3:K3,"NCCO")+1
My problem is when I go to the next cell the is jumps numbers equal to how many cells are used
EX.
=21000+COUNTIFS('2022'!$D$3:D5,D4,'2022'!$K$3:K5,"CO",'2022'!$K$3:K5,"NCCO")+1
=21000+COUNTIFS('2022'!$D$3:D7,D5,'2022'!$K$3:K7,"CO",'2022'!$K$3:K7,"NCCO")+1
=21000+COUNTIFS('2022'!$D$3:D9,D6,'2022'!$K$3:K9,"CO",'2022'!$K$3:K9,"NCCO")+1
^ ^ ^
I put arrows where the numbers jump. Why would it do that and not follow the order? I can not seem to stop this.
I am constantly having to create numbering sequences that look like this:
100 000001
100 000002
three numbers, space and then 6 numbers with only the last 6 numbers increasing. What would be the formula to achieve that?
Thanks
Hi!
You can use a custom number format to repeat zeros.
Use the TEXT function to display a number in this custom format.
="100 " & TEXT(SEQUENCE(100,,1,1),"*00000##")
Hope this is what you need.
how about
KD1-20
KD21-40
KD41-60
and so on.
tnx
Hi!
Try the following formula:
="KD"&CEILING(SEQUENCE(100,1,1,20)/1,1)&"-"&CEILING(SEQUENCE(100,1,1,20)/1,1)+19
i forgot something formula for
1kd 1 - 20
2kd 21 - 40
3kd 41 - 60
4kd 61 - 80
thank u sir godbless
Hello Sr
how can I do a sequence of rows every 8 repetitive number, every 8 rows same number, then the next one 8 times, etc. Example: the patern is same number 8 rows or 8 times, then next number ther 8 rows or times:
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
thank you
Hello!
Please use the following formula
=CEILING(SEQUENCE(800,1,1,1)/8,1)
Thanks
thank you
I want to generate this kind of number but I am having difficulty. Anyone can help me?
=VLOOKUP(G2,O2:P23,2,FALSE)
=VLOOKUP(G3,O2:P23,2,FALSE)
=VLOOKUP(G4,O2:P23,2,FALSE)
=VLOOKUP(G5,O2:P23,2,FALSE)
=VLOOKUP(G6,O2:P23,2,FALSE)
=VLOOKUP(G7,O2:P23,2,FALSE)
=VLOOKUP(G8,O2:P23,2,FALSE)
=VLOOKUP(G9,O2:P23,2,FALSE)
=VLOOKUP(G10,O2:P23,2,FALSE)
The G Is the one only rising. Thank you to anyone who can help.
Hi!
When you copy the formula down the column, G2 will change to G3, G4, and so on.
would it be possible to sequence numbers but end on the number that is in the next column.
example:
1 6
2 6
3 6
4 6
5 6
6 6
1 3
2 3
3 3
1 5
2 5
We are using the info for a data merge for bundles. so the outcome would be "Bundle 1 of 6"
Thank you
Hello!
You have not written what is the source data. I am assuming column B. Perhaps this formula will work -
=COUNTIF($B$1:B1,B1)
After that you can copy this formula down along the column.
If this is not what you wanted, please describe the problem in more detail.
Sorry, Can you tell I don't know what I'm doing?
I was able to plug this in and worked. But I do see when I scroll down and some of the "bundles" are combined together and then go back to correct sequence. what could cause this?
example: Source is column B.
1 8
2 8
3 8
4 8
5 8
6 8
7 8
8 8
8 7
9 7
10 7
11 7
12 7
13 7
14 7
1 9
2 9
3 9...
Hello!
What formula are you using?
The formula used was =COUNTIF($B$1:B1,B1)
After some testing I realized that the repeating bundles would start from the previous similar bundles. see below.
example:
1 5
2 5
3 5
4 5
5 5
1 7
2 7
3 7
4 7
5 7
6 7
7 7
6 5
7 5
8 5
9 5
10 5
Hello,
What would the formula be to create this sequence?
A1001A A1001B A1001C A1001D A1002A A1002B A1002C A1002D A1003A A1003B A1003C A1003D
A1004A A1004B A1004C A1004D A1005A A1005B A1005C A1005D A1006A A1006B A1006C A1006D
Where the last letter in the series ends with "D", but the preceding number will increase as the sequence proceeds.
Thanks
Hello!
If I understand your task correctly, the following formula should work for you:
="A"&(1000+CEILING(SEQUENCE(1000,1,1,1)/4,1)) & CHOOSE(TRUNC(MOD((ROW(A1:A1000)-1)/1,4)+1),"A","B","C","D")
Hope this is what you need.
I have 4 sheets , the number of rows is random for each sheet. How to make the sequential number continue from sheet 1 to sheet 4 meanwhile the number of rows is random .
Hello!
Find the maximum number on the previous sheet using the MAX function and add 1 to it.
=MAX(Sheet2!A:A)+1
Then, on the current sheet, simply add 1 to this number.
I want sequence something like this:
1
2
1
2
1
2
1
2
.
.
.
.
.
etc.
how to achieve this?
Hi!
A sequence is a series of consecutive numbers: 1,2,3 ... or 3,5,7 ... Each next number is not less than the previous one.
Your example is not a sequence. Write 1 and 2 in the cells and copy them down the column.
i want a sequence where number is skipped
eg. sequence of days where sunday is skipped
1
2
3
4
5
6
8
9
10
11
12
13
15 ......
Hello!
The formula below will do the trick for you:
=SEQUENCE(300,1,1,1)+CEILING(SEQUENCE(300,1,1,1)/6,1)-1
Hope this is what you need.
DEAR SIR
I want to make sequence in different cells i mean selected cells .
make select cells and put sequence in selected cell .
not upcoming cell.
Hi!
An Excel formula can only work over a continuous range. It is not possible to select individual cells.
I have a sequence of numbers, let's say:
1
3
4
20
22
and would like Excel to return on a cell(another sheet) the next available number in the given column, starting in 1 to n, if this makes sense.
Is this possible?
Thanks
Hello!
Write down your numbers starting at cell A2. Write this formula in cell B2
=MIN(FILTER(SEQUENCE(100,1,1,1),(SEQUENCE(100,1,1,1)>A2)*(SEQUENCE(100,1,1,1)<>A3)*(SEQUENCE(100,1,1,1)<>B1)))
and then copy it down along the column.
You can learn more about FILTER function in Excel in this article on our blog.
Hope this is what you need.
i have a sequence of number
AAA0001 --- AAA9999 , after the 9999 the next number i need is AAB0001 and continue increasement .
please help , and the alphabet increase is without "I" and "o" .
thanks !
ok I have refined my previous answer a little
set $C$2 to either 999 or 9999 depending on the number series you want
then use this formula to get the series you asked for.
No letters i or o and skip from 9999 to 0001
This was a fun puzzle!!!
=IF(SEQUENCE(1048576)>$C$2*24^2,"B","A") & CHAR(65 + INT(MOD(SEQUENCE(1048576)/(24*$C$2)- 0.000001,24)) + IFS(INT(MOD(SEQUENCE(1048576)/(24*$C$2)- 0.000001,24))>12,2,INT(MOD(SEQUENCE(1048576)/(24*$C$2)- 0.000001,24))>7,1,TRUE,0)) & CHAR(65 + INT(MOD(SEQUENCE(1048576)/($C$2)- 0.000001,24)) + IFS(INT(MOD(SEQUENCE(1048576)/($C$2)- 0.000001,24))>12,2,INT(MOD(SEQUENCE(1048576)/($C$2)-0.000001,24))>7,1,TRUE,0)) & RIGHT("00000" & ROUNDUP(MOD(SEQUENCE(1048576),($C$2)+0.000001),0),LEN(C2))
for even more fun ;o)
you can use this formula and drag from a1 to k1 or more
This will continue the series since column limit in excel doesn't go far enough for your series
in this case the number series 999 or 9999 is in $M$2
=CHAR(65 + INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/(24^2*$M$2)- 0.0000001,24)) + IFS(INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/(24^2*$M$2)- 0.0000001,24))>12,2,INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/(24^2*$M$2)- 0.0000001,24))>7,1,TRUE,0)) & CHAR(65 + INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/(24*$M$2)- 0.0000001,24)) + IFS(INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/(24*$M$2)- 0.000001,24))>12,2,INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/(24*$M$2)- 0.000001,24))>7,1,TRUE,0)) & CHAR(65 + INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/($M$2)- 0.000001,24)) + IFS(INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/($M$2)- 0.000001,24))>12,2,INT(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576))/($M$2)-0.000001,24))>7,1,TRUE,0)) & RIGHT("00000" & ROUNDUP(MOD((SEQUENCE(1048576)+((COLUMN()-1)*1048576)),($M$2)+0.000001),0),LEN($M$2))
Hi, thank you, Sir Alexander, I'm working on making a sequence of Admission number like
1910404001
19104040002
1910404003
,,,,
,,,,,
,,,
Please help me, thank you?
Hi,
The constant 1910404 can be combined with a changing value using the & operator. To always have 3 digits in a number, use the TEXT function.
I’ll try to guess and offer you the following formula:
=1910404&TEXT(SEQUENCE(100,1,1,1),"000")
How can i make sequence of number series with one column or row blank.
1 2 3 4 5 6
- - - - - -
7 8 9 10 11
- - - - - -
Hi,
You can use the formula
=SEQUENCE(1,10,1,1)
Hi, I am looking to take data from one column and create a sequential number in another column. However the data in my reference column (location codes) are duplicated in more than one row but I need my sequential number column to be the same value for each location code. Example: My first entry is Location code K051 that has three rows of data so it's sequential number should be 1 for each of the three rows. Next location code is K052 that has five rows of data so it's sequential number column should be 2 for each of it's 5 rows.
Each location code could have a varying amount of rows associated.
Is there a formula that can create these sequential numbers? Thank you!
Hello!
If the Location code is written in column A, the order number of each code can be obtained using the formula
=MATCH(A2,UNIQUE($A$2:$A$20),1)
After that you can copy this formula down along the column.
i want to make a series of 3 digit 'n' numbers
please help
Hi,
You can get 3-digit numbers with this formula:
=SEQUENCE(900,1,100,1)
If this is not what you wanted, please describe the problem in more detail.
Hi,
I'm trying to generate a sequence of numbers in the below order. Could you please help?
40000 / 01
40002 / 03
40004 / 05
40006 / 07
40008 / 09
...
...
...
etc
Hello!
The formula below to solve your task:
=40000+(ROW(A1)-1)*2&" / "&TEXT(ROW(A1)*2-1,"00")
Hi Alex,
Highly appreciate your quick response. Excel shows that 'there's a problem with this formula'.
Thanks again!!!
Thomas
I'm wondering if anyone could help me.
I am trying to generate some 1-column sequences like this:
1001-01
1001-02
1001-03
1002-01
1002-02
1002-03
1003-01
1003-02
1003-03
1004-01
(etc.)
Hello!
If I understand your task correctly, the following formula should work for you:
=CEILING(ROW(A3001)/3,1)&" - 0"&TRUNC(MOD((ROW(A1)-1)/1,3)+1)
I hope my advice will help you solve your task.
this works great but how do I use a dynamic function with the solution?
I have 2 numbers set by the user: a1 = 15 and b1 = 3
from these two inputs I would like to dynamically create a sequence that goes:
1.1
1.2
1.3
2.1
2.2
.... until 15.3
is this possible?
Hi!
Replace A3001 with A1 in the formula above.
Thank you for your reply. I understood how that worked but the ideal solution for me is one that uses a dynamic array. not a drag down approach.
Hello!
Instead of the ROW function, use SEQUENCE:
=CEILING(SEQUENCE(45,1,1,1)/3,1)&"."&TRUNC(MOD((SEQUENCE(45,1,1,1)-1)/1,3)+1)
Hope this is what you need.
yes but that is not making use of the dynamic array function
after playing around with John's "puzzle" below I came up with this to solve my own issue:
=INT(MOD(SEQUENCE($A$1*$B$1,1,0,1)/$B$1,$A$1)) + 1 & "." & MOD(SEQUENCE($A$1*$B$1,1,0,1),$B$1) + 1
somehow doing it with letters from the AAA0001 loop helped me figure out my own loop better.
I am wondering if you can make a sequence where the number changing is not the last character? I want it to be like this, with the stars included? I need it to go from 1-99. Thanks for the help!!
*R1-01-01-01*
*R1-01-01-02*
*R1-01-01-03*
*R1-01-01-04*
*R1-01-01-05*
Hi!
If I got you right, the formula below will help you with your task:
="*R1-01-01-"&TEXT(SEQUENCE(99,1,1,1),"00")&"*"
Hope this is what you need.
Hello
Sir I want generate the series of mobile phone numbers like 2301230000 to 2301239999 I don't know how I can?
Hello Farhan,
You can use a formula like this:
=SEQUENCE(9999,1,2301230000)
Where 9999 is how many numbers you want to generate.
Hi thank you so much for your informative guidance.
I have a question. How would the sequence function work in case I wanted to repeat the same number twice?
e.g.
2175
2175
2176
2176
2177
2177
2178
2178
etc.
Thanks appreciate your help!
Sir, how to make a formula for consecutive numbers but different from dates
Example
01 jan 2021 02 jan 2021
1028365-628 1034664-629
Thanks
Hello!
Use the following formula/the formula below to solve your task:
=CEILING(ROW(A4349)/2,1)
After that you can copy this formula down along the column.
I want a generate a sequence of numbers in order from 1 to 25. But have them starting again from 1 after 25. How would I modify this formula to satisfy this.
Hello!
For automatic line numbering from 1 to 25, use the formula
=TRUNC(MOD((ROW(A1)-1),25)+1)
After that you can copy this formula down along the column.
so if I need to make my number start from 10001 :
how it should look like
I have the same , I need to have a sequence number generated automatically and continuance from page one to the next page ... I need to use this sequence as an order number so every time I place an order I have to get an automatic number ... is it possible ?
thank you & appreciate
Interesting piece! I am creating a spreadsheet for my wife who is a potter. All pieces, let's say 'started', are listed in the spreadsheet starting 1 and obviously going down the sheet 2,3,4 etc. However, owing to the nature of her activity, not all pieces get to the point of being saleable items - thus, the final product codes for the saleable items are also consecutive, but there might be gaps between rows, where certain pieces are rejected i.e. product code 0001,0002, gap, gap, gap, 0003 etc. Is it possible, perhaps using a second column next to the Product Code column to use something like an IFISBLANK to work with SEQUENCE, so that, for example a Y (for yes) can be added to the first column, which then lets SEQUENCE add in the next column, the next sequential product code number - if that makes sense ?
Hello!
If you want to create automatic numbering in a column, write 1 in cell C1, and the formula in cell C2:
=MAX($C$1:$C1)+1
After that you can copy this formula down along the column.
You can make some of the cells in column C blank. The numbering will continue from the next nonblank cell.
I hope I answered your question. If something is still unclear, please feel free to ask.
Fantastic - much appreciated - exactly what I needed!
Hello
Sir I want generate the series of mobile phone numbers like +92301230000 to +92301239999 I don't know how I can.
Hi, use below:
=SEQUENCE(9999,1,92301230000,1)
IT NOT WORK