Iwe unogona kugadzira arrays muMicrosoft Excel asina kuchengetwa mumaseru maseru. Vanowanzonzi mitsara yezvinogara. Muchidzidzo ichi, iwe uchadzidza kuti ndeapi anogara ari arrays uye maitiro ekushanda nawo muExcel.
Muchidimbu nezve arrays of constants
Kuti ugadzire mutsara wezvigadziriso, isa zvinhu zvayo uye uzvivhare mumabhanhire akamonana. Semuenzaniso, mufananidzo uri pazasi unoratidza mutsara unosanganisira 6 zvinoramba zviripo:
={1;2;3;4;5;6}
Rondedzero yakadaro inogona kushandiswa muExcel mafomula. Semuenzaniso, iyo inotevera fomula inopfupisa kukosha kweiyi array:
=СУММ({1;2;3;4;5;6})
Mafomura anogona kubata akawanda arrays panguva imwe chete. Semuenzaniso, iyo inotevera fomula inodzosa kukosha kwepamusoro kunoguma nekuwedzera mitsara miviri yemaconstants:
=МАКС({1;2;3;4;5;6}+{7,8,9,10,11,12})
Constant arrays inogona kuve nenhamba, zvinyorwa, booleans, uye kukanganisa kukosha # N / A:
={12;"Текст";ИСТИНА;ЛОЖЬ;#Н/Д}
Ungava nemubvunzo une musoro: Nei tichida ndandanda yakadaro? Ndichaipindura nemuenzaniso.
Muenzaniso wekushandisa ruzhinji rwemaconstants muExcel
Nhamba iri pazasi inoratidza runyorwa rwevadzidzi vakagamuchira mamwe mamakisi:
Basa redu ndere kushandura ongororo kubva pachimiro chenhamba kuita tsananguro yezwi uye kuratidza hunhu hunoenderana murudzi C2: C7. Muchiitiko ichi, hazvina musoro kugadzira tafura yakaparadzana yekuchengetedza tsananguro yemavara emagiredhi, saka zvinonyanya kubatsira kugadzira iyo inotevera dhizaini yeanogara:
={"";"Неудовл.";"Удовл.";"Хорошо";"Отлино"}
Muchiitiko ichi, chinhu chekutanga chechikwata chine tambo isina chinhu, nokuti inofungidzirwa kuti hapagoni kuve nekuongororwa kwe1.
Ipapo iyo formula inodzosa mhedzisiro yatinoda ichaita seizvi:
Mumuenzaniso uyu, basa INDEX inodzosa kukosha kwechinhu kubva mumutsara wezvimiro, nzvimbo yacho inopiwa nenhamba yeordinal (score).
Iyi fomula haisi yakarongwa, kunyangwe iine array. Naizvozvo, pakupinda mairi, zvakakwana kudzvanya kiyi pinda.
Ehe, isu tinogona kukopa iyi fomula kune mamwe ese maseru uye towana mhedzisiro yatinoda:
Asi zvingave zvine hungwaru kushandisa akawanda-sero array formula. Ichaita seizvi:
Tinogona kuenda zvakatopfuura uye kupa ruzhinji rwezvisingachinji zita. Iro zita rinopihwa nenzira yakangofanana neyenguva dzose, kuburikidza nebhokisi rebhokisi Gadzira zita:
Usakanganwa kuisa chiratidzo chakaenzana mumunda dungwerungwe, kana zvisina kudaro Excel inobata rondedzero setambo yemavara.
Iye zvino fomula yacho inotaridzika isingatyisidzi:
Sezvauri kuona, mune dzimwe nguva arrays anogara achitobatsira zvakanyanya.
Saka, muchidzidzo chino, iwe wakajairana nemitsara yezvisingachinji uye kushandiswa kwavo muExcel. Kuti uwane rumwe ruzivo nezve arrays, verenga zvinotevera zvinyorwa:
- Nhanganyaya kune array mafomula muExcel
- Multicell array formula muExcel
- Single cell array formula muExcel
- Kugadzirisa mafomula muExcel
- Kushandisa array formulas muExcel
- Maitiro ekugadzirisa array mafomula muExcel