- Umsebenzi we-SEQUENCE udala uhlu lwezinombolo ezilandelanayo ngokwenza ngezifiso imigqa, amakholomu, ukuqala, kanye nokwenyuka.
- Ingahlanganiswa neminye imisebenzi efana ne-TEXT, DATE, ROW, noma i-RANDOM ukudala amakhalenda, idatha yokuhlola, kanye nezinombolo eziguquguqukayo.
- I-SEQUENCE iyatholakala ezinguqulweni zanamuhla ze-Excel kanye naku-Google Sheets, ngomehluko omncane we-syntax yesifunda.
- Kunezindlela ezihlukile zokudala ukulandelana (hudula, gcwalisa, i-Apps Script), kodwa i-SEQUENCE inikeza ikhambi eliguquguqukayo nelizenzakalelayo kakhulu.
Uma uke wazithola uthayipha ngesandla u-1, 2, 3… kuspredishithi , uyazi ukuthi kungomunye wemisebenzi ekhathazayo kakhulu emhlabeni. Futhi uma kungewona nje imigqa eyi-10 kodwa engu-500 noma engu-1000, isuka ekubeni yinto ekhathazayo iye kwengabekezeleleki. Ngenhlanhla, i-Excel kanye ne-Google Sheets zinomsebenzi oklanyelwe ngqo lokhu: UHLELO LOKULANDELANA , olukwazi ukudala uhlu lwezinombolo ngobuningi ngefomula eyodwa.
Nakuba kungase kuzwakale njengobuchwepheshe kancane, umsebenzi we-SEQUENCE ulula kakhulu kunalokho okubonakala. Ngezimpikiswano ezimbalwa ezichazwe kahle, ungakha amathebula aphelele ezinombolo ezi-odiwe, ukukhulisa noma ukunciphisa uchungechunge , izinsuku ezixhunyiwe, amakhodi e-accounting, ngisho nedatha yesampula yemibiko yakho. Ake sibheke kabanzi ukuthi isebenza kanjani ku-Excel kanye ne-Google Sheets, nokuthi ungazuza kanjani kakhulu kukho ngezibonelo zangempela namathiphu awusizo.
Iyini umsebenzi we-SEQUENCE futhi usetshenziselwani?
Umsebenzi we-SEQUENCE usetshenziselwa ukukhiqiza uhlu lwezinombolo ezilandelanayo "ezidlula" ishidi lokusebenzela, ezithatha imigqa namakholomu amaningi. Ngamanye amazwi, ufaka ifomula kuseli, bese igcwalisa ngokuzenzakalelayo ibhulokhi lonke ngezinombolo ezilandelanayo.
Ukuziphatha kwayo kufana kakhulu ku-Excel naku-Google Sheets: kuzo zombili izimo, ukufaka ifomula kuzokunikeza i- array eguquguqukayo . Lokhu kusho ukuthi umphumela awuyona inani elilodwa, kodwa isethi yamaseli agcwaliswa ngokuzenzakalelayo kusukela kuseli yokuqala.
Cabanga ukuthi udinga ithebula eliqala ku-1 liye ku-20 emigqeni emi-4 namakholomu ama-5. Esikhundleni sokuligcwalisa ngenombolo ngenombolo, ubuzosebenzisa nje u- =SEQUENCE(4;5) (esimisweni sesifunda esisebenzisa i-semicolon) noma u-=SEQUENCE(4,5) (esimisweni sesifunda esisebenzisa i-comma), futhi yilokho kuphela: uzoba nebhulokhi engu-4x5 enezinombolo ezisukela ku-1 kuya ku-20.
Lo msebenzi uwusizo kakhulu uma ufuna ukudala uchungechunge lwezinombolo olulawulwayo : ukubala phezulu noma phansi, ukugxuma ngama-10, ukukhiqiza izihlonzi, ukulingisa idatha, noma ukulungiselela izakhiwo zemibiko, amadeshibhodi, noma amathebula e-pivot ku-Excel.
I-syntax ye-SEQUENCE ku-Excel naku-Google AmaSpredishithi
Incazelo esemthethweni ye-SEQUENCE ifana kakhulu kuzo zombili amathuluzi. I-syntax ejwayelekile ithi:
I-syntax evamile: =SECUENCIA(filas; columnas; inicio; incremento)
Impikiswano ngayinye inendima ethile, futhi kubalulekile ukuyiqonda kahle ukuze ukwazi kahle umsebenzi wayo futhi uthole okuningi kuyo:
| ingxenye | Descripción |
filas |
kuyadingeka. Kubonisa inani lemigqa i-matrix ephumayo ezoba nayo. Ukuphakama kwebhulokhi yezinombolo okuzokhiqizwa. |
columnas |
OngakukhethaIcacisa inani lamakholomu ku-array. Uma kushiywa kungenalutho, umsebenzi ubuyisela ikholomu eyodwa kuphela. |
inicio |
OngakukhethaLena inombolo lapho ukulandelana kuzoqala khona. Uma kungacacisiwe, ukubala kuqala ku-1 ngokuzenzakalelayo. |
incremento |
OngakukhethaLokhu kubonisa ukuthi ukulandelana kuzoqhubeka noma kuzobuyela emuva kangakanani. Uma kushiywe ngaphandle, kuyanda ngo-1; uma kungenayo, ukulandelana kuzobuyela emuva. |
Kuye ngezilungiselelo zakho zesifunda, umsebenzi ungase wamukele i-comma noma i-semicolon njengesihlukanisi sempikiswano. ESpain, i-semicolon iyindinganiso ku-Excel naku-Google Sheets: =SEQUENCE(4;5) . Kodwa-ke, uma unamathisela isibonelo ngama-comma bese kubuyisa iphutha, mane uwafake esikhundleni sama-semicolon.
Isihluthulelo ukuqonda ukuthi imigqa namakholomu kunquma usayizi we-array , kuyilapho i-start kanye ne-increment kulawula inani lenombolo yokuqala kanye nosayizi wesinyathelo phakathi kwenombolo eyodwa nelandelayo.
Izibonelo eziyisisekelo zokusetshenziswa kwe-SEQUENCE
Izibonelo zakudala zokuqonda ukuthi i-matrix egcwele "ipendwe" kanjani eshidini.
Isibonelo 1: UHLELO OLUNGENE nemigqa kuphela
Isibonelo ku-A1: Uma uthayipha okulandelayo kuseli A1:
Ifomula esheshayo: =SECUENCIA(2)
Ifomula izobuyisa uhlu oluqondile olunemigqa emi-2 nekholomu eli-1 , oluzogcwaliswa kanje:
| A | B | |
| 1 | 1 | |
| 2 | 2 |
Qaphela ukuthi, ngokungacacisi amakholomu, umsebenzi ubuyisela ikholomu eyodwa enamanani angu-1 no-2. Lokhu kuziphatha kuvame ukusetshenziselwa ukudala uhlu oluqondile olulula olunezinombolo kusukela ku-1 kuya ku-n.
Isibonelo 2: i-matrix yemigqa namakholomu amaningana
Ku-A1: Uma manje ubhala ku-A1:
Ifomula ye-matrix: =SECUENCIA(2;3)
Umsebenzi uzokhiqiza i-matrix yemigqa emi-2 namakholomu ama-3 . Ububanzi be-A1:C2 buzobukeka kanje:
| A | B | C | |
| 1 | 1 | 2 | 3 |
| 2 | 4 | 5 | 6 |
| 3 |
Inqubo ihamba umugqa nomugqa, kusukela kwesobunxele kuya kwesokudla : kuqala u-A1, bese kuba u-B1, u-C1, bese kuba u-A2, u-B2, u-C2, njll. Lokhu kugcwalisa ngokuzenzakalelayo izinombolo kusukela ku-1 kuya ku-6 ngaphandle kokuthayipha noma yiziphi ngesandla.
Isibonelo 3: ukulawula ukuqala nokwenyuka
Uma ufuna ukuthi uhlu lungaqali ku-1 noma lukhuphuke ngabanye, ungacacisa izimpikiswano `zokuqala` kanye `zokwanda`. Zama lokhu:
Ifomula 3-2: =SECUENCIA(2;3;3;2)
Umphumela: Umphumela kusukela ku-A1 kuqhubeke uzoba:
| A | B | C | |
| 1 | 3 | 5 | 7 |
| 2 | 9 | 11 | 13 |
| 3 |
Uchungechunge luqala ku -3 bese lukhuphuka ngo- 2 : 3, 5, 7, 9, 11, 13… futhi, lugcwalisa umugqa ophezulu kuqala bese kuba umugqa ongezansi.
Isibonelo 4: ukulandelana kokwehla
Ukwenyuka okungekuhle: Ungakha futhi uhlu olubuyela emuva usebenzisa ukwenyuka okungekuhle. Isibonelo:
Ifomula yokwehla: =SECUENCIA(2;3;10;-1)
Ukulandelana okunciphisayo: Kudala ithebula elinezinombolo ezinciphayo eziqala ku-10:
| A | B | C | |
| 1 | 10 | 9 | 8 |
| 2 | 7 | 6 | 5 |
| 3 | 4 | 3 | 2 |
Ngaleli qhinga ungasetha ukubala phansi okulawulwayo ngezinyathelo ezimbalwa nje, ngokumane ulungise inani lemigqa namakholomu ukuze kufakwe wonke amanani afunwayo.
Uhlu oluqondile, uhlu oluvundlile kanye nokuguqulwa kwe-SEQUENCE
Ngokuzenzakalelayo, uma ushiya impikiswano yamakholomu, i-SEQUENCE ibuyisela uhlu oluqondile . Okusho ukuthi, uzoba nekholomu eyodwa enemigqa eminingi njengoba uyicacisile kupharamitha yokuqala. Lokhu kuvame kakhulu uma ufuna uhlu lwezinombolo kukholomu eyodwa.
Uma okudingayo uhlu oluvundlile (emgqeni owodwa), unezinketho ezimbili ezilula kakhulu: noma usetha imigqa = 1 bese ulawula usayizi osele ngamakholomu, noma udala uhlu oluvundlile bese ulushintsha ngomunye umsebenzi.
Isibonelo esisheshayo: Isibonelo, ukudala umugqa onezinombolo kusukela ku-1 kuya ku-10, ungasebenzisa:
Ifomula evundlile: =SECUENCIA(1;10)
Futhi uma usuvele une-sequence eqondile, ungayiguqula ibe evundlile ngokusebenzisa, isibonelo ku-Excel, umsebenzi we- TRANSPOSE() kuleyo matrix: ngale ndlela uzosuka ohlwini lwekholomu eyodwa uye emgqeni onenani elifanayo.
Lolu hlobo lokuhlanganiswa luwusizo kakhulu uma ulungiselela izihloko zamathebula, izinyanga zilandelana, noma izinombolo ezivundlile ngaphandle kokukopisha, ukunamathisela noma ukuhudula.
Izibonelo ezisebenzayo ze-SEQUENCE ku-Excel
Ukusetshenziswa okusebenzayo: Imibhalo ye-Excel ikhombisa ukusetshenziswa okuthakazelisayo kwe-SEQUENCE kuhlanganiswe neminye imisebenzi, eyenzelwe ukwakha idatha eguquguqukayo ngokushesha.
Isibonelo esidala sihilela ukukhiqiza i -matrix yemigqa emi-4 namakholomu ama-5 ngokumane:
Ifomula 4×5: =SECUENCIA(4;5)
Ngale fomula uzothola ibhulokhi lezinombolo elihleliwe kusukela ku-1 kuya ku-20, elingasebenza njengedatha yokuhlola kanye nokwakha amathempulethi noma amaspredishithi adinga ukubalwa kwezinombolo okucacile.
Dala umugqa wezinyanga zonyaka wamanje
Ukusetshenziswa okuthakazelisa kakhulu ukusebenzisa i-SEQUENCE ngokuhambisana nemisebenzi yokufometha usuku nombhalo. Cabanga ukuthi ufuna umugqa wezinyanga (Jan, Feb, Mar, njll.) ohlala ubuyekeza unyaka wamanje ngaphandle kokuthi ushintshe noma yini ngesandla.
Ifomula ephakanyiswe yiMicrosoft ihlanganisa i-TEXT, USUKU, UNYAKA, NAMUHLA, kanye ne-SEQUENCE ngale ndlela:
=TEXTO(FECHA(AÑO(HOY());SECUENCIA(1;6);1);"mmm")
Le fomula yenza okulandelayo: ithatha unyaka wamanje isebenzisa i-YEAR(TODAY()) , ikhiqiza izinombolo zenyanga kusukela ku-1 kuya ku-6 (Januwari kuya kuJuni) isebenzisa i-SEQUENCE(1;6 ), idala izinsuku nge -DATE(year; month; day) , bese ekugcineni izibonisa zifinyeziwe nge -TEXT(…;"mmm") . Umphumela uba umugqa onezinyanga eziyisithupha zokuqala zonyaka, ohlala uvuselelwa unyaka wamanje.
Dala uhlu olukhulayo lwezinombolo ezingahleliwe
Esinye isibonelo esisemthethweni sihlanganisa i-SEQUENCE ne -INTEGER kanye ne-RANDOM ukuthola uhlu lwezinombolo ezingahleliwe ezikhulayo, eziwusizo ekukhiqizeni idatha yobuqili yokuhlola:
Ifomula engahleliwe: =SECUENCIA(5;6;ENTERO(ALEATORIO()*100);ENTERO(ALEATORIO()*100))
Imisebenzi engahleliwe isetshenziswa lapha ukuchaza kokubili inombolo yokuqala kanye nokwenyuka. Umphumela uba yi- matrix engu-5x6 yezinombolo ezilandela inqubekela phambili, kodwa amanani azo ashintsha njalo lapho ispredishithi ibalwa kabusha.
Uhlu lwamakhodi e-accounting noma izihlonzi
Uma usebenza nge-accounting noma udinga ukukhiqiza amakhodi okubhekisela , i-SEQUENCE ingakongela isikhathi esiningi. Isibonelo, nge:
Amakhodi efomula: =SECUENCIA(5;1;1001;1000)
Amanani aphumelayo: Uthola ikholomu yemigqa emi-5 enamanani alandelayo: 1001, 2001, 3001, 4001 kanye no-5001. Kuyindlela eshesha kakhulu yokukhiqiza izinombolo "ezingenazo izikhala" ongazisebenzisa njengamakhodi esikhungo sezindleko, ama-akhawunti e-accounting noma izihlonzi zamakhasimende noma amaphrojekthi.
UHLELO LOKULANDELANA ku-Google Sheets: ukusetshenziswa okuvamile kanye nezici ezithile
Ku-Google Sheets, umsebenzi we -SEQUENCE usebenza cishe ngendlela efanayo nowe-Excel. Uphinde ubuyisele uhlu oluchitheka lusuka kuseli lomthombo futhi lwabelana nge-syntax yempikiswano efanayo: imigqa, amakholomu, isiqalo, ukwanda.
Isibonelo esisheshayo: Isibonelo esilula singaba:
Amashidi efomula: =SEQUENCE(5;1;1;1)
okudala ikholomu yemigqa emi-5, eqala ku-1 bese ikhula ngo-1. Kungumqondo ofanayo ncamashi nowase-Excel, kuphela ku-interface ye-Google Sheets.
Inzuzo enkulu ye-SEQUENCE kuma-Sheets ukuthi ikuvumela ukuthi ulawule ngokulandelana kwezinombolo ngokuguquguqukayo futhi uzihlanganise kalula neminye imisebenzi yethuluzi ngokwalo, noma ngama-array osuvele uwadalile usebenzisa i-ARRAYFORMULA, ROW, njll.
Amaqhinga okubhala izinombolo alula uma kuqhathaniswa nokudonsa nokulahla
Kuyiqiniso ukuthi ku-Google Sheets ungabhala izinombolo ngokushesha kumaseli usebenzisa icebo elivamile lokudonsa isibambo sokugcwalisa . Isibonelo, uthayipha u-1 ku-A1, u-2 ku-A2, ukhethe kokubili, bese uhudula phansi: ishidi lithola iphethini bese liqhubeka no-3, 4, 5…
Ungasebenzisa futhi imenyu ethi Hlela → Gcwalisa → Uchungechunge ukuze udale uhlu olude ngaphandle kokulihudula isikhathi eside. Lapho ungacacisa isinyathelo (1, 2, 10, njll.) kanye nomkhawulo wokugcina.
Noma kunjalo, zonke lezo zindlela ziyi -static : uma uhlu selukhiqizwe, uma ufaka imigqa, ushintsha isakhiwo, noma udinga ukushintsha ububanzi, kufanele wenze kabusha i-padding. Nge-SEQUENCE, ngakolunye uhlangothi, izinombolo ziyazivumelanisa ngokuzenzakalelayo uma ushintsha inani lemigqa ku-array noma ulungisa ifomula.
I-ROW, i-ARRAYFORMULA kanye ne-Apps Script njengezinye izindlela
Ku-Google Sheets, kunezinye izindlela ezidumile zokufaka izinombolo, ikakhulukazi uma ufuna into eguquguqukayo kodwa ungadingi ukuguquguquka okugcwele kwe-SEQUENCE. Enye inketho evamile ukusebenzisa umsebenzi we-ROW() kanje:
Ifomula Yomugqa: =FILA()-FILA($A$1)+1
Ukubala Kabusha: Umqondo uwukuthi ngokunamathisela leyo fomula kuseli yakho yokuqala bese uhudula phansi, umugqa ngamunye ubala inombolo yawo yokuhleleka. Uma ufaka umugqa omusha ngenhla, ukubala kabusha kuhlala kufana futhi izinombolo zihlala zilungisiwe kahle.
Uma ufuna ukuya phambili, ungahlanganisa i-ROW ne -ARRAYFORMULA ukuze ugcwalise lonke ibanga ngesikhathi esisodwa usebenzisa ifomula eyodwa:
Ifomula ye-ARRAY: =ARRAYFORMULA(FILA(A1:A100)-FILA(A1)+1)
Ukufaka izinombolo 1-100: Lokhu kudala ngokuzenzakalelayo izinombolo kusukela ku-1 kuya ku-100 kukholamu oyikhethayo, ngaphandle kokuhudula. Ngokushintsha i-A100, ungalungisa usayizi njengoba kudingeka.
Okokugcina, kubasebenzisi abathuthukile, i-Google Apps Script ikuvumela ukuthi udale ukulandelana nge -logic yangokwezifiso ; ku-Excel, ungakwazi futhi ukwenza imisebenzi ngokuzenzakalela ngokuhlela ama-macro . Isibonelo, ungabhala iskripthi esifushane esigcwalisa izinombolo ezingajwayelekile kuphela, ukubalwa emuva ngokweqa okungajwayelekile, noma ububanzi bezinombolo ngokusekelwe ezimweni ezithile.
Izinkinga ezivamile: amaseli ahlanganisiwe kanye nama-array agcwele kakhulu
Enye yezinto ezidida kakhulu kubasebenzisi abasha be-Google Sheets ukuzama ukusebenzisa i-SEQUENCE kumaseli ahlanganisiwe . Uma, isibonelo, unamaqembu amaseli amane ahlanganisiwe futhi ufuna ibhulokhi ngayinye ibonise inombolo ekubaleni phansi (1500, 1496, 1492, njll.), i-SEQUENCE iyodwa ayisebenzi kahle naleso sakhiwo.
Ama-array aguquguqukayo, kokubili kuma-Sheets kanye ne-Excel, adinga isikhala esingaphazanyiswa ukuze agcwale. Uma ububanzi abazama ukubunweba buqukethe amaseli ahlanganisiwe, okuqukethwe okukhona, noma imikhawulo, cishe uzohlangana namaphutha noma ungaboni umphumela olindelekile.
Kulezo zimo, kungaba ngcono kakhulu ukuqala ngokudala ukulandelana ku-range ehlanzekile, engahlanganisiwe , bese usebenzisa izinkomba, amafomula engeziwe, noma ngisho neskripthi esincane ukufaka inani ngalinye ku-block yeseli ehlanganisiwe oyithandayo.
Ngaphezu kwalokho, ku-Excel yanamuhla, lapho uhlu olugcwele luhlangana nedatha evimbayo, iphutha elithi #OVERFLOW! livame ukuboniswa . Kunconywa ukuthi ubukeze le milayezo, usule indawo uma kudingeka, futhi uqinisekise ukuthi akukho datha ekhona kakade ephazamisa umphumela we-SEQUENCE.
Imisebenzi ehlobene kanye nezinhlanganisela eziwusizo
Inhlanganisela ewusizo: I-SEQUENCE ayisetshenziswa kakhulu lapho ifuna izixazululo ezinamandla. Ngokuvamile ihlanganiswa neminye imisebenzi ye-dynamic array kanye ne-data generation.
Ku-Excel , imisebenzi efana ne -VLOOKUP kanye neminye imisebenzi esekelayo ivame ukusebenza kahle kakhulu kanye ne-SEQUENCE:
- I-M.UNIT (noma okufanayo enguqulweni yakho), okubuyisela i- i-matrix yobunikazi yobukhulu obucacisile, kanye nalabo abaku-diagonal kanye no-zero kokunye.
- I-RANDARRAY / I-MATRIZALEAT, ekwazi ukukhiqiza ama-matrices ezinombolo ezingahleliwe, angasebenza njengesisekelo sokulingisa noma izivivinyo.
- ISIHLUNGI, okukuvumela ukuthi ukhethe kuphela imigqa noma amakholomu ahlangabezana nezimo ezithile kusuka ku-matrix ekhiqizwe nge-SEQUENCE.
- HLELA bese UHLENGA NGOKUTHI, ukuhlela kabusha idatha ekhiqizwe nge-SEQUENCE, isibonelo uma ufuna izinombolo ezincike ku-oda lenye ikholomu.
- UNICOSLokhu kuyasiza uma udala uhlu futhi ufuna ukugcina amanani angaphindi kuphela.
Lawa mabhulokhi omsebenzi, kanye nomqondo wama- dynamic arrays kanye nokuziphatha kwe-overflow , avumela ukwakhiwa kwezixazululo ezithuthukisiwe ngaphandle kokusebenzisa ama-macros noma izinhlelo eziyinkimbinkimbi.
Ku-Google Sheets, ukuhlanganisa i-SEQUENCE ne -ARRAYFORMULA , FILTER , SORT , UNIQUE , noma imisebenzi yedethi efana ne -TODAY, EOMONTH , njll., kuvula umnyango wemibiko ebuyekezwayo namadeshibhodi akhiqiza ukulandelana kwawo ngokusekelwe kudatha etholakalayo.
Izinzuzo ngaphezu kokubhala izinombolo ngesandla noma ngamaqhinga ayisisekelo
Uma kuqhathaniswa nezindlela zendabuko (ukubhala ngesandla, ukudonsa isibambo sokugcwalisa, noma ukusebenzisa imenyu ethi Fill/Series), umsebenzi we-SEQUENCE unezinzuzo eziningana ezibalulekile ekusetshenzisweni kwansuku zonke :
Ngakolunye uhlangothi, ikuvumela ukuthi udale uhlu olude kakhulu (amakhulu noma izinkulungwane zemigqa) ngaphandle kokuskrola noma ukuhudula. Mane ucacise inani lemigqa namakholomu, bese i-matrix ivele ngokushesha—kulula kakhulu uma usebenza ngedatha enkulu.
Ngakolunye uhlangothi, ukulandelana okukhiqizwe nge-SEQUENCE kulula ukukugcina . Uma kamuva udinga ukwandisa noma ukunciphisa ububanzi, umane ushintshe impikiswano yomugqa noma ikholomu, ngaphandle kokuphinda wenze noma yini ngesandla. Ngaphezu kwalokho, njengoba kuyifomula, zingancika kwamanye amaseli, okukuvumela ukuthi udale ukulandelana okukhula noma okuncipha ngokuzenzakalelayo ngokusekelwe ezimweni ezithile.
Gwema amaphutha omuntu: Elinye iphuzu elithakazelisayo ukuthi i-SEQUENCE igwema amaphutha avamile omuntu: ukukhohlwa inombolo, ukweqa eyodwa ngengozi, noma ukuyiphinda ungahlosile. Ngokunikeza lo msebenzi umsebenzi, uqinisekisa ukuthi izinombolo zihambisana futhi ziyaqhubeka, kokubili ekubaleni okwenyukayo nokwehlayo.
Okokugcina, ngokukwazi ukulawula ukuqala nokwenyuka, umsebenzi uvumelana ngokuphelele nezimo ezihluke kakhulu: kusukela ekubhaleni izinombolo emibhalweni kuya ekudaleni uchungechunge lwezinsuku zesikhathi, ukukhiqiza amakhodi obuchwepheshe noma ukusetha izakhiwo zokulingisa idatha.
Isikhathi esincane: Lapho nje uqala ukuyisebenzisa, uzobona ukuthi imisebenzi eyayivame ukuthatha imizuzu eminingana (noma ngisho nangaphezulu) incishiswa yaba ukubhala ifomula eyodwa, ecatshangelwe kahle.
Ngokusebenzisa i-SEQUENCE ku-Excel kanye ne-Google Sheets, ukuyihlanganisa nemisebenzi yedethi, umbhalo, ukuhlunga, noma i-dynamic array, ispredishithi yenza umsebenzi onzima: ukufaka izinombolo, ukudala uchungechunge, kanye nokukhiqiza idatha ehlelekile kuba yindaba yemizuzwana, ngamafomula okulula ukuwalungisa futhi cishe awekho ingozi yamaphutha enziwe ngesandla.
