Muchidzidzo chino, tichajairana ne-single-cell array formula uye tiongorore muenzaniso wakanaka wekushandiswa kwayo muExcel. Kana iwe usati wanyatso jairana neakarongwa mafomula, isu tinokurudzira kuti iwe utange wavhura kuchidzidzo, icho chinotsanangura misimboti yekushanda nearrays muExcel.
Kushandisa Single Cell Array Formula
Kana iwe ukaverenga chidzidzo nezve ma-multi-cell array formula, ipapo mufananidzo uri pazasi unoratidza tafura yagara yaunoziva kwauri. Panguva ino basa redu nderekuverenga mutengo wakakwana wezvinhu zvese.
Ehezve, isu tinokwanisa kuita yemhando yepamusoro uye nekungopeta kukosha kubva kumhando yemasero D2: D6. Nekuda kweizvozvo, iwe unowana yaunoda mhedzisiro:
Asi pane mamiriro ezvinhu kana uchiita zvepakati kuverenga (munyaya yedu, iyi ndiyo nhanho D2: D6) haina musoro, haigoneki kana kuti haigoneki zvachose. Mune ino kesi, imwe-sero array formula inouya kununura, iyo inobvumidza iwe kuverenga mhedzisiro neformula imwe chete. Kuisa fomula yakadaro muExcel, tevera matanho aya:
- Sarudza sero paunoda kuti mhedzisiro ioneke:
- Isa fomura inotevera:
- Sezvo iyi iri array formula, iyo yekuisa inofanirwa kupedzwa nekutsikirira musanganiswa Ctrl + Shift + Pinda. Nekuda kweizvozvo, tinowana mhedzisiro yakafanana neyakaverengerwa kare.
Iyi fomula inoshanda sei?
- Iyi fomula inotanga kuwanda hunoenderana kukosha kweiyo mitsara miviri:
- Uye zvichibva pane yakagamuchirwa data, inogadzira mutsva wakatwasuka unowanikwa muRAM yemukombuta chete:
- Zvadaro basa SUM inoverengera kukosha kweiyo array uye inodzosera mhedzisiro.
Array mafomula -Ichi ndicho chimwe chezvakanyanya kuoma, uye panguva imwechete inobatsira, zvishandiso muMicrosoft Excel. Single-cell array formulas inokubvumira kuti uite masvomhu asingagone kuitwa neimwe nzira. Muzvidzidzo zvinotevera, tichatarisa mienzaniso yakawanda yakadaro.
Saka, muchidzidzo chino, wakajairana ne-single-cell array formula uye wakaongorora muenzaniso wekugadzirisa dambudziko riri nyore. Kana iwe uchida kudzidza zvakatowanda nezve arrays muExcel, verenga zvinotevera zvinyorwa:
- Nhanganyaya kune array mafomula muExcel
- Multicell array formula muExcel
- Zvirongwa zvezvimiro muExcel
- Kugadzirisa mafomula muExcel
- Kushandisa array formulas muExcel
- Maitiro ekugadzirisa array mafomula muExcel