Skip i'r prif gynnwys

Sut i ailadrodd dilyniant rhif yn Excel?

A ydych erioed wedi ceisio llenwi colofn gyda dilyniant ailadroddus o rifau yn Excel? Er enghraifft, rwyf am lenwi'r golofn â 1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4. A oes unrhyw ddull cyflym i ddatrys y broblem hon yn Excel?

Ailadroddwch rif rhif yn Excel gyda'r fformiwla

swigen dde glas saeth Ailadroddwch rif rhif yn Excel gyda'r fformiwla

I ailadrodd y dilyniant rhif, gall y fformiwla syml ganlynol eich helpu chi.

1. Rhowch rif 1 mewn cell lle rydych chi am roi'r rhifau dilyniant dro ar ôl tro, byddaf yn ei nodi yng nghell A1.

2. Dilynwch y gell, yna teipiwch y fformiwla hon = Weinyddiaeth Amddiffyn (A1,4) +1 i mewn i gell A2, gweler y screenshot:

doc-ailadrodd-dilyniant-1

3. Yna llusgwch y ddolen llenwi i'r celloedd rydych chi am gynnwys y fformiwla hon, a byddwch chi'n cael y rhifau dilyniant dro ar ôl tro, gweler y screenshot:

doc-ailadrodd-dilyniant-1

Nodiadau:

1. Yn y fformiwla uchod, A1 yw'r gell y gwnaeth eich rhif cyntaf aros ynddi, ac mae'r rhif 4, yn nodi'r rhif dilyniant a ailadroddir. Os oes angen ailadrodd y dilyniant arnoch fel 1, 2, 3, 4, 5, 1, 2, 3, 4, 5, mae angen ichi newid y 4 i 5 yn unig.

2. Ac mae'r fformiwla hon yn cael ei chymhwyso i'r dilyniant rhif syml yn unig, os ydych chi am ailadrodd dilyniant llinyn y testun, fel A1001, A1002, A1003, ni fydd y fformiwla hon yn gweithio.

3. Rhaid i'ch rhif dilyniant fod yn cychwyn o rif 1, os na, gall canlyniad y fformiwla fod yn anghywir.

 

Offer Cynhyrchiant Swyddfa Gorau

🤖 Kutools AI Aide: Chwyldro dadansoddi data yn seiliedig ar: Cyflawniad Deallus   |  Cynhyrchu Cod  |  Creu Fformiwlâu Personol  |  Dadansoddi Data a Chynhyrchu Siartiau  |  Invoke Swyddogaethau Kutools...
Nodweddion Poblogaidd: Darganfod, Amlygu neu Adnabod Dyblygiadau   |  Dileu Rhesi Gwag   |  Cyfuno Colofnau neu Gelloedd heb Colli Data   |   Rownd heb Fformiwla ...
Super-edrych: VLookup Meini Prawf Lluosog  |   VLookup Gwerth Lluosog  |   VLookup Ar Draws Taflenni Lluosog   |   Edrych Niwlog ....
Rhestr gwympo Uwch: Creu Rhestr Gollwng yn Gyflym   |  Rhestr Gollwng Dibynnol   |  Rhestr Gollwng Aml-ddewis ....
Rheolwr Colofn: Ychwanegu Nifer Penodol o Golofnau  |  Symud Colofnau  |  Toglo Statws Gwelededd Colofnau Cudd  |  Cymharwch Ystodau a Cholofnau ...
Nodweddion dan Sylw: Ffocws ar y Grid   |  Golwg Dylunio   |   Bar Fformiwla Mawr   |  Rheolwr Llyfr Gwaith a Thaflen   |  Llyfrgell Adnoddau (Testun Auto)   |  Dewiswr Dyddiad   |  Cyfuno Taflenni Gwaith   |  Amgryptio/Dadgryptio Celloedd   |  Anfon E-byst trwy Restr   |  Hidlo Super   |   Hidlo Arbennig (hidlo mewn print trwm/italig/strikethrough...) ...
15 Set Offer Gorau:  12 Testun offer (Ychwanegu Testun, Dileu Cymeriadau,...)   |   50 + Siart Mathau (Siart Gantt,...)   |   40+ Ymarferol Fformiwlâu (Cyfrifwch oedran yn seiliedig ar ben-blwydd,...)   |   19 mewnosod offer (Mewnosod Cod QR, Mewnosod Llun o'r Llwybr,...)   |   12 Trosi offer (Rhifau i Eiriau, Trosi arian cyfred,...)   |   7 Uno a Hollti offer (Rhesi Cyfuno Uwch, Celloedd Hollt,...)   |   ... a mwy

Supercharge Eich Sgiliau Excel gyda Kutools ar gyfer Excel, a Phrofiad Effeithlonrwydd Fel Erioed Erioed. Kutools ar gyfer Excel Yn Cynnig Dros 300 o Nodweddion Uwch i Hybu Cynhyrchiant ac Arbed Amser.  Cliciwch Yma i Gael Y Nodwedd Sydd Ei Angen Y Mwyaf...

Disgrifiad

Mae Office Tab yn dod â rhyngwyneb Tabbed i Office, ac yn Gwneud Eich Gwaith yn Haws o lawer

  • Galluogi golygu a darllen tabbed yn Word, Excel, PowerPoint, Cyhoeddwr, Mynediad, Visio a Phrosiect.
  • Agor a chreu dogfennau lluosog mewn tabiau newydd o'r un ffenestr, yn hytrach nag mewn ffenestri newydd.
  • Yn cynyddu eich cynhyrchiant 50%, ac yn lleihau cannoedd o gliciau llygoden i chi bob dydd!

 

Comments (15)
No ratings yet. Be the first to rate!
Tilak B
Tilak B
This comment was minimized by the moderator on the site
if the Number is A1 to A15 (1 to 15 number) I want in D1 to I1 number (3 to 8) A2 to F2 Rows & E1 to J1 number (4 to 9) A3 to F3 Rows.. Likewise, .. Is there any formula for reparation?
Reply
0
0
Ale
Ale
This comment was minimized by the moderator on the site
Bom dia, como consigo fazer uma sequencia de números porem com ano fixo exemplo: 700/2022, 701/2022, 702/2022
Reply
0
0
Jo
Jo
This comment was minimized by the moderator on the site
How do I Excel formula for following?
seq with step of five 1,6,11,16,21,26
next seq with step of five 2,7,12,22,27
next seq with step of five 3,8,13,23,28
Result 1,6,11,16,21,26,2,7,12,22,27,3,8,13,23,28
=(MOD(SEQUENCE(A3);A2)) But how do you and a step to the next seq?
Reply
0
0
skyyang
skyyang     Jo
This comment was minimized by the moderator on the site
Hi, Jo,
Sorry, I can't get your problem clearly, so give you a formula as this:
=ROW()&","&ROW()+5&","&ROW()+10&","&ROW()+20&","&ROW()+25

https://www.extendoffice.com/images/stories/comments/comment-skyyang/doc-sequence-number.png
If it's not what you want, please comment here. And you can insert your problem as screenshot here.
Thank you!
Reply
Report
0
0
Bryanv
Bryanv
This comment was minimized by the moderator on the site
Hi,i need help. It takes up to much time typing 1 by 1.

Ex.

Scc 1 pt 1
Scc 1 pt 1
Scc 2 pt 2
Scc 2 pt 2

Sorry, im a beginner. I type it 1 by 1. When i drag it down the sequence is like this:

Scc 1 pt 1
Scc 1 pt 2
Scc 1 pt 3

How do I repeat it twice and and sequence like the first example?
Reply
0
0
skyyang
skyyang     Bryanv
This comment was minimized by the moderator on the site
Hello Bryanv,
Maybe the following formula can do you a favor:

="Scc "&INT((ROW(A1)-1)/2+1)&" pt "&INT((ROW(A1)-1)/2+1)

Tips: If you want to repeat the sequence n times, you just need to change the number 2 to whatever number you want in the formula.

Please try, hope it can help you!
Reply
Report
0
0
Revanth
Revanth     skyyang
This comment was minimized by the moderator on the site
Hi, Can the same formula is used for the following sequence

Sample1 rep1
sample1 rep2
sample1 rep3
sample1 rep4
sample 2 rep1
sample2 rep2
sample 2 rep3
sample2 rep4


If not can you help me to create the above type of sequence
Reply
Report
0
0
skyyang
skyyang     Revanth
This comment was minimized by the moderator on the site
Hello, venkata,
To solve your problem, please apply the below formula:

="Sample"&INT((ROW(A1)-1)/4+1)&" rep"&1+MOD(ROW()-1,4)

Please have a try, hope it can help you!
Reply
Report
0
0
Revanth
Revanth     skyyang
This comment was minimized by the moderator on the site
Can I use the same formula for
sequence like

Sample1 rep1
sample1 rep2
sample1 rep3
sample1 rep4
sample 2 rep1
sample2 rep2
sample 2 rep3
sample2 rep4
Reply
0
0
SANJEEV KUMAR
SANJEEV KUMAR
This comment was minimized by the moderator on the site
MY MOBILE NUMBER IS E.G. 11244-99666CAN I KNOW DIGIT 6 COMES HOW MANY TIMES IN MY MOBILE NUMBER
Reply
0
0
Steve
Steve
This comment was minimized by the moderator on the site
How can you do this with the first number in the sequence being zero? Ex. 00,10,20,30,00,10,20,30....
Reply
0
0
Wannes
Wannes     Steve
This comment was minimized by the moderator on the site
if you want the first number to be 0, you can use the following formula:
=MOD(A1 + 1, 4)
Reply
0
0
Gab
Gab
This comment was minimized by the moderator on the site
It doesn't work if you have zero as the first number in the pattern
Reply
0
0
jhall100.jh@gmail.com
This comment was minimized by the moderator on the site
How do I return "1" for x rows, then "2" for x rows, then "3" for x rows, etc.....
Reply
Report
0
0
Wannes
Wannes    
This comment was minimized by the moderator on the site
If x = 10, you could write down the first 10 1's (or autofill them) in A1:A10. Then at A11 you put down "=A1 + 1", which you then autofill as far as you want. Only works if x is the same for each number.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations