Muchidzidzo chino, tichajairana ne-multi-cell array formula, ongorora muenzaniso wakanaka wekushandiswa kwayo muExcel, uye zvakare cherechedza zvimwe zvekushandisa. Kana iwe usiri kujairana neakarongwa mafomula, tinokurudzira kuti utange wavhura kuchidzidzo, icho chinotsanangura misimboti yekushanda navo.
Kushandisa multicell array formula
Mufananidzo uri pasi apa unoratidza tafura ine zita rechigadzirwa, mutengo wayo uye huwandu. Masero D2: D6 anoverenga mutengo wakazara werudzi rwega rwechigadzirwa (uchifunga nezvehuwandu).
Mumuenzaniso uyu, iyo D2: D6 ine mafomu mashanu. Iyo yakawanda-sero array formula inobvumidza iwe kuverenga mhedzisiro imwe chete uchishandisa imwechete formula. Kuti ushandise array formula, tevera matanho aya:
- Sarudza huwandu hwemasero kwaunoda kuratidza mhinduro. Muchiitiko chedu, iyi ndiyo mhando D2: D6.
- Sezvakaita chero fomula muExcel, danho rekutanga nderekuisa chiratidzo chakaenzana.
- Sarudza nhamba yekutanga yezvinokosha. Kwatiri, iyi ndiyo nhanho ine mitengo yezvinhu B2:B6.
- Pinda chiratidzo chekuwedzera uye bvisa mutsara wechipiri wezvinokosha. Kwatiri, iyi nhanho ine nhamba yezvigadzirwa C2: C6.
- Dai taizoisa fomula yenguva dzose muExcel, taizopedzisa kupinda nekudzvanya kiyi pinda. Asi sezvo iyi iri array formula, unofanirwa kudzvanya kiyi musanganiswa Ctrl + Shift + Pinda. Izvi zvinoudza Excel kuti iyi haisi fomula yenguva dzose, asi yakarongwa fomula, uye inozvivharira otomatiki mumabaraki.
Excel inozvivharira otomatiki fomula yakatevedzana mune dzakamonana braces. Kana ukaisa mabhuraketi nemaoko, Excel inodudzira chirevo ichi sechinyorwa chakajeka.
- Ziva kuti maseru ese ari muchikamu cheD2:D6 ane matauriro akafanana. Mabrace akamonereka akaitenderedza anoratidza kuti iri array formula.
- Kana isu takasarudza diki renji kana tapinda muakarongedzerwa fomula, semuenzaniso, D2:D4, zvino yaizodzosera chete mibairo mitatu yekutanga kwatiri:
- Uye kana huwandu hwakakura, ipapo mu "mamwe" masero paizova nekukosha # N / A (hapana data):
Kana tikawanza danga rekutanga nerechipiri, zvinhu zvawo zvinowedzerwa (B2 neC2, B3 neC3, B4 neC4, nezvimwewo). Somugumisiro, hutsva hutsva hunoumbwa, hune migumisiro yekuverenga. Naizvozvo, kuti uwane mhedzisiro chaiyo, zviyero zveese matatu arrays anofanirwa kuenderana.
Benefits ye multicell array formula
Muzviitiko zvakawanda, kushandisa imwechete-multi-cell array formula muExcel zviri nani kushandisa akawanda ega mafomula. Funga nezvemabhenefiti makuru ainopa:
- Uchishandisa multi-cell array formula, une 100% chokwadi chekuti mafomula ese ari muchikamu chakaverengerwa akaiswa nemazvo.
- Iyo array formula inodzivirirwa zvakanyanya kubva mukushanduka netsaona, sezvo chete hurongwa hwese hunogona kugadziridzwa. Kana iwe ukaedza kushandura chikamu chehurongwa, iwe unokundikana. Semuenzaniso, kana ukaedza kudzima fomula kubva muchitokisi D4, Excel inoburitsa yambiro inotevera:
- Hauzokwanisi kuisa mitsetse mitsva kana makoramu muchikamu panopinzwa fomula yehurongwa. Kuisa mutsara mutsva kana koramu, unozofanirwa kutsanangura patsva rondedzero yese. Pfungwa iyi inogona kutorwa seyakanakira nezvayakaipira.
Saka, muchidzidzo chino, iwe wakajairana ne-multi-cell array formula uye wakaongorora muenzaniso mudiki. Kana iwe uchida kudzidza zvakatowanda nezve arrays muExcel, verenga zvinotevera zvinyorwa:
- Nhanganyaya kune array mafomula muExcel
- Single cell array formula muExcel
- Zvirongwa zvezvimiro muExcel
- Kugadzirisa mafomula muExcel
- Kushandisa array formulas muExcel
- Maitiro ekugadzirisa array mafomula muExcel