Skip to main content

Conas seicheamh uimhreacha a athdhéanamh in Excel?

An ndearna tú iarracht riamh colún a líonadh le seicheamh athrá uimhreacha in Excel? Mar shampla, ba mhaith liom an colún a líonadh le 1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4. An bhfuil aon mhodh gasta ann chun an fhadhb seo a réiteach in Excel?

Déan seicheamh uimhreacha arís in Excel leis an bhfoirmle


mboilgeog cheart gorm saighead Déan seicheamh uimhreacha arís in Excel leis an bhfoirmle

Chun seicheamh na n-uimhreacha a athdhéanamh, d’fhéadfadh an fhoirmle shimplí seo a leanas cabhrú leat.

1. Iontráil uimhir 1 isteach i gcill inar mian leat na huimhreacha seicheamh arís agus arís eile a chur, cuirfidh mé isteach é i gcill A1.

2. Lean an chill, ansin clóscríobh an fhoirmle seo = MOD (A1,4) +1 isteach i gcill A2, féach an scáileán:

doc-athrá-seicheamh-1

3. Ansin tarraing an láimhseáil líonta chuig na cealla ar mhaith leat an fhoirmle seo a bheith iontu, agus gheobhaidh tú na huimhreacha seicheamh arís agus arís eile, féach an scáileán:

doc-athrá-seicheamh-1

Nótaí:

1. San fhoirmle thuas, A1 an cill ar fhan do chéad uimhir inti, agus an uimhir 4, léirítear an uimhir seicheamh arís agus arís eile. Más gá duit an seicheamh a athdhéanamh mar 1, 2, 3, 4, 5, 1, 2, 3, 4, 5, ní gá duit ach an 4 go 5 a athrú.

2. Agus cuirtear an fhoirmle seo i bhfeidhm díreach ar an seicheamh uimhreacha simplí, más mian leat seicheamh na sreanga téacs a athdhéanamh, mar shampla A1001, A1002, A1003, ní oibreoidh an fhoirmle seo.

3. Caithfear d’uimhir seicheamh a thosú ó uimhir 1, mura bhfuil, d’fhéadfadh go mbeadh toradh na foirmle mícheart.

 

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup    VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle    Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla    Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc


Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!

 

Comments (15)
No ratings yet. Be the first to rate!
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?
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
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?
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!
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?
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!
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
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!
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
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
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....
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)
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
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.....
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.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations