Excel Magic Trick 1114: Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2...

See how to create formula for Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 1, 18443 2, 18444 2, 18445 2, 18446 3.... See formula that uses the functions ROWS, INT and the join symbol Ampersand &
Formula element to create sequential numbers like 18440, 18441, 18442.
Formula element to create repeating numbers like 1, 1, 1, 2, 2, 2, 3, 3, 3....

Here is the direct link to the MOST amazing article ever written about speed, Macro for timing and Volatile functions (by Charles Williams):

Szilvia "High Priestess of Excel"
History of Excel:

[michalroesler]

ExcelIsFun, thank you for this video very much. You truly are a diamond in YouTube community.

[excelisfun]

Excel Magic Trick 1114: Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2... 

[yuridiastefania]

Hello friend, it is the first time that I see your videos and I liked them a lot with regard to Excel and Word. I only base it on them and I really want to learn to use these programs well since in my work I use them a lot all day watching your videos. I realized that you are an expert using excel I want to ask you do you have a video or could you make a video how to make formulas to find repeated numbers or names I know I have the option in excel of conditional formatting, highlight cells rules, duplicates values but I want to learn how to make formulas and also you know how to make a file to extract cvs. well thank you very much

[zmjerry]

Hi Mr Excelsfun, do you think this could be done using the new Sequence function in Microsoft 365?

[BattleSymphony]

How do you fill room numbers,
Like
201a
, 201b,
202a,
202b.... etc

[bevonclarke]

I have a list say: A, B, C, D, F (IN COLUMN A)
I want the user to select a member of the above list in column B1 and say how many times it must be repeated in column C1. The extracted list can now follow in any other column (a multiple of times say 2)
Example. 
User selected A
Repeat 3
List 2 times 

The desired output would then be:
A
A
A
B
C
D
E
A
A
A
B
C
D
E

blanks further on.

Please and thank you in advance.
Bevon Clarke

[imranali-iywk]

hello john
I have some problem in excel when I found duplicate names in excel just like when I find Ahmad raza name found in same column Mr. Ahmad raza Dr. Ahmad raza what I do?

[orange]

434 views? For real? This simple video have may save our species some day and people prefers Gangnamstyle video

[RStaRaptoR]

just drag the sequence of 2 or more by the bottom right edge. the next vid answers my question.

[esh]

thank you but what if i want
1
1
1
2
2
2
3
3
3
4
4
4

[michalroesler]

ExcelIsFun, thank you for this video very much. You truly are a diamond in YouTube community.