Funda indlela iirrays ezinokuba lula ngayo umsebenzi kwi-Excel
Uhlu luluhlu okanye iqela leempawu zedatha ehambelanayo. Kwiiprogram ze-spreadsheet ezifana ne-Excel kunye ne-Google Spreadsheets, ixabiso kwi-array zigcinwa rhoqo kwiiseli eziseduze.
Ukusetyenziswa kweeArrays
Iingxowa zingasetyenziselwa kwiifomula zombini (iifomula zamaphepha) kunye neengxoxo malunga nemisebenzi efana neefom ze-LOOKUP kunye ne- INDEX .
Iintlobo zeeArrays
Kukho ezimbini iintlobo zee-arrays kwi-Excel:
- I-one-dimensional array, eyaziwa ngokuba yintengiso okanye i-vector. Idatha ikhona:
- kumqolo omnye (i-one-dimensional horizontal array).
- kwikholamu enye (i-one-dimensional vertical array).
- Ididi ezimbini-dimensional, ezaziwa nangokuthi i-matrix
- Idata ifumaneka kwiikholomu ezininzi okanye imigqa.
- Uluhlu lwetafile - Itheyibhile yoluhlu lunye lweengxabano ezisetyenziselwa imisebenzi ye-Excel yokulanda, njengeVLOOKUP kunye neHLOOKUP.
- IMISEBENZI YOKUKHALA ifuna uphendlo lwetafile ukufumana ulwazi oluthe ngqo.
- Nge-VLOOKUP (ukujonga ngokubonakalayo), i-table_array kufuneka ibe neenkcukacha ezimbini zedatha .
- Nge-HLOOKUP (ukulandeleka kwe-horizontal), i-table_array kufuneka ibe neyuncinane imigqa yedatha.
Uqwalaselo lweFormula
Ifomula yoluhlu luyi- formula eyenza izibalo - ezifana nokudibanisa, okanye ukuphinda-phinda - kwiimpawu kwisinye okanye kwizinto ezingaphezulu kwexabiso elithile.
Iifomula zohlobo:
- sebenzisa i-syntax efanayo njengamafomula aqhelekileyo (bonke baqala uphawu olulinganayo (=) umzekelo).
- sebenzisa abaxhamli beemathematika abafanayo.
- kwaye landela umyalelo ofanayo wokusebenza.
Iifomula zoHlelo kunye neMisebenzi ye-Excel
Ininzi yemisebenzi eyakhelwe ngaphakathi-njenge-SUM, AVERAGE, okanye COUNT - ingasetyenziselwa kwifomula yomhlathi.
Kukho nemisebenzi embalwa - njenge-TRANSPOSE function - ekufuneka ihlale ifakwe njengoluhlu ukwenzela ukuba isebenze ngokufanelekileyo.
Ubuncedo bemisebenzi eminingi efana ne-INDEX kunye ne-MATCH okanye i-MAX kunye ne-IF ingahanjiswa ngokuyisebenzisa ndawonye kwifomula yomhlathi.
CSE Ifomu
Kwi-Excel, iifomula ezidibeneyo zizungezwe ngamabhonki "" } ". Ezi bhonkco azikwazi ukuba zifakwe kuphela kodwa kufuneka zongezwe kwifomu ngokucinezela i-Ctrl, Shift, kunye neefayile zokungena emva kokufakela ifomu kwifom okanye kwiiseli.
Ngesi sizathu, iifom zoluhlu ngamanye amaxesha zibizwa ngokuba ngumhlathi we-CSE kwi-Excel.
Imbandela kule migaqo yilapho i-brace brace isetyenziselwa ukufaka uluhlu njengengxabano yomsebenzi oqhelekileyo uqulethe ixabiso elilodwa okanye i- cell reference .
Umzekelo, kwikhowudi engezantsi esebenzisa i-VLOOKUP kunye nomsebenzi wokukhetha ukudala ifom ye-lookup yokushiya, i-array idalwe kwi-CHOOSE function Index_num argument ngokuthayipha iibhondi ezijikelezayo.
Amanyathelo okudala i-form Formula
- Faka ifom.
- Gcina iCtrl kunye neShift iqhosha kwikhibhodi.
- Cinezela kwaye ukhulule ukhiye we- Enter ukudala ifom yokulandelelana.
- Ukukhupha ii- Ctrl kunye neShift .
Ukuba kwenziwe ngokuchanekileyo, ifomula iya kujikelezwa ngamabhonki kunye kunye neseli nganye ephethe ifomu iya kuba nomphumo ohlukileyo.
Ukuhlela i-Formula yohlobo
Naliphi na ixesha i-formula yolungiselelo ihlelwe ngayo i-curly braces yanyamalala ukusuka kwinqanaba lomgaqo.
Ukuzibuyisela kwakhona, ifomula yefayile kufuneka ifakwe ngokucinezela i-Ctrl, Shift, kunye neefayile zokungenisa kwakhona njengokuba i-formula yangaphambili yenziwe.
Iintlobo zeeFom form
Kukho ezimbini iindidi zeefomula zamanani:
- Ifom ye-Multi-cell array formula, apho ifomula efanayo ifumaneka kwisitya esingaphezu kwesinye kwiphepha lokusebenzela;
- Isalathisi esisodwa seeselfowuni, apho ifom enye ifaka izibalo ezininzi kwiseli yomsebenzi omnye.
Iimfomula ezininzi zee-Cell
Njengoko igama labo libonisa, ezi fomula ziyahlula kwiiseli ezininzi zamaphepha kwaye zibuyisela uluhlu njengempendulo.
Ngamanye amagama, ifomula efanayo ifumaneka kwiiseli ezimbini okanye ngaphezulu kwaye ubuyisela iimpendulo ezahlukileyo kwiselinye ngasinye.
Indlela okwenza ngayo le nto kukuba ikopi nganye okanye umzekelo wefomula yoluhlu yenza ukubala okufanayo kwiseli nganye ekhoyo, kodwa umzekelo ngamnye wefomula isebenzisa idatha eyahlukileyo kubalo kwaye ke ngoko, umzekelo ngamnye uvelisa iziphumo ezahlukeneyo.
Umzekelo wefomula yamanxeba amaninzi uza kuba:
{= A1: A2 * B1: B2}
Iifomula zeeNombolo eziLodwa
Uhlobo lwesibini lweifomula zamanzi lusebenzisa umsebenzi - njenge-SUM, ISIGABA, okanye i-COUNT - ukudibanisa umkhiqizo wefomula yamanqanaba emininzi kwixabiso elinye.
Umzekelo wesalathisi esisodwa sefom yefayile yayiya kuba:
{= SUM (A1: A2 * B1: B2)}