Kugadzirisa mafomula muExcel

Muzvidzidzo zvakapfuura, takakurukura mazano ekutanga uye ruzivo nezve arrays muExcel. Muchidzidzo chino, tichaenderera mberi nekudzidza mafomula, asi nekusimbisa zvakanyanya pakushanda kwawo. Saka, iwe unoshandura sei yatove iripo array formula muExcel?

Mitemo yekugadzirisa array formula

Kana array formula yakaiswa mune imwe sero, wozoigadzirisa muExcel kazhinji haina kunyanya kuoma. Chinhu chikuru pano hachisi chekukanganwa kupedzisa kugadzirisa nemusanganiswa wakakosha Ctrl + Shift + Pinda.

Kana iyo fomula iri multicell, kureva kuti inodzosa array, ipapo mamwe matambudziko anobva amuka, kunyanya kune vashandisi vekutanga. Ngatitarisei mitemo mishoma yaunofanirwa kunzwisisa usati watanga kugadzirisa array.

1. Iwe haugone kushandura zviri mukati mesero rimwe rine array formula. Asi sero rega rega rinogona kuve nemafomati aro.
2. Iwe haugone kudzima maseru ari chikamu chearray formula. Iwe unogona chete kudzima array yese.
3. Iwe haugone kufambisa maseru ari chikamu cheakarongwa fomula. Asi iwe unogona kufambisa array yese.
4. Haukwanise kupinza maseru matsva, kusanganisira mitsetse nemakoramu, muhurongwa.
5. Iwe haugone kushandisa multicell array formula mumatafura akagadzirwa nemirairo tafura.

Sezvaunogona kuona, mitemo yose yakanyorwa pamusoro inosimbisa kuti mutsara umwechete. Kana iwe ukasatevedzera kana imwe yemitemo iri pamusoro, Excel haingakuregi uchigadzirisa hurongwa uye ichakupa inotevera yambiro:

Kusarudza array muExcel

Kana iwe uchida kushandura array formula, chinhu chekutanga kuita kusarudza iyo ine hurongwa. MuExcel, pane angangoita matatu nzira dzekuita izvi:

1. Sarudza array range nemaoko, kureva kushandisa mbeva. Iyi ndiyo yakapfava, asi mune zvimwe zviitiko zvachose isina kukodzera nzira.
2. Kushandisa dialog box Sarudza boka remasero. Kuti uite izvi, sarudza chero sero riri reiyo array:Uye ipapo paKumba tebhu kubva pane yekudonha pasi runyorwa Tsvaga uye sarudza watinya Sarudza boka remasero.

   

   A dialog box richavhura Sarudza boka remasero. Seta bhatani redhiyo kune Current Array wobva wadzvanya OK.

   

   Iyo yazvino array icharatidzwa:

   

3. Kushandisa misanganiswa yakakosha CTRL+/. Kuti uite izvi, sarudza chero sero mune array uye tinya musanganiswa.

Maitiro ekudzima array formula

Chinhu chiri nyore chaungaita nearray muExcel ndiko kuidzima. Kuti uite izvi, ingosarudza iyo yaunoda array uye tinya kiyi Kudzima.

Maitiro ekugadzirisa array formula

Nhamba iri pazasi inoratidza array formula iyo inowedzera kukosha kwemarenji maviri. Zvinogona kuonekwa kubva pamufananidzo kuti pakupinda fomu, takaita chikanganiso chiduku, basa redu nderekugadzirisa.

Kugadzirisa array formula, ita zvinotevera:

1. Sarudza huwandu hwehurongwa uchishandisa chero nzira dzinozivikanwa kwauri. Muchiitiko chedu, iyi ndiyo mhando C1: C12.
2. Chinja kune formula editing mode nekudzvanya pane formula bar kana nekudzvanya kiyi F2. Excel inobvisa iyo yakamonana braces yakatenderedza array formula.
3. Ita zvigadziriso zvinodiwa kune formula:
4. Uye wobva wadzvanya kiyi musanganiswa Ctrl + Shift + Pindakuchengetedza shanduko. Iyo formula ichagadziriswa.

Resize array formula

Kazhinji kazhinji panodiwa kudzikisa kana kuwedzera huwandu hwemasero mune array formula. Ini ndichataura ipapo ipapo kuti iri harisi basa riri nyore uye muzviitiko zvakawanda zvichave nyore kudzima dhizaini yekare uye kugadzira imwe nyowani.

Usati wadzima hurongwa hwekare, kopira fomula yacho semavara wobva waishandisa muhurongwa hutsva. Nemaforoma anorema, nzira iyi inochengetedza nguva yakawanda.

Kana iwe uchida kushandura nzvimbo yearray papepa rekushanda pasina kushandura chiyero chayo, ingoifambisa seyakajairwa.

Pane nzira dzakati wandei dzekugadzirisa masaizi array aungawane anobatsira. Maitiro anopiwa muchidzidzo ichi.

Saka, nhasi wadzidza kusarudza, kudzima uye kugadzirisa mafomula, uye zvakare wakadzidza mimwe mitemo inobatsira yekushanda navo. Kana iwe uchida kudzidza zvakatowanda nezve arrays muExcel, verenga zvinotevera zvinyorwa:

• Nhanganyaya kune array mafomula muExcel
• Multicell array formula muExcel
• Single cell array formula muExcel
• Zvirongwa zvezvimiro muExcel
• Kushandisa array formulas muExcel
• Maitiro ekugadzirisa array mafomula muExcel