Kazhinji, kana uchishanda muExcel, unofanirwa kuverenga nhamba yemasero papepa rekushanda. Aya anogona kunge asina kana masero akazadzwa ane manhamba chete, uye mune dzimwe nguva, zvirimo zvinofanirwa kuzadzisa mamwe maitiro. Muchidzidzo ichi, isu tichatarisa zvakadzama maitiro maviri makuru eExcel ekuverenga data - Check и COUNTIF, pamwe nekujairana nevasina mukurumbira - SCHETZ, COUNTBLANK и COUNTIFS.
CHECK()
nhamba basa Check inoverenga nhamba yemasero ari mugwaro renharo rine nhamba chete. Semuenzaniso, pamufananidzo uri pasi apa, takaverenga nhamba yemasero muhuwandu hunosanganisira nhamba dzose:
Mumuenzaniso unotevera, masero maviri emhando ane mavara. Sezvauri kuona, basa racho Check anovafuratira.
Asi masero ane zuva uye nguva kukosha anotariswa:
basa Check inogona kuverenga huwandu hwemasero mune akati wandei asina- contiguous siyana kamwechete:
Kana iwe uchida kuverenga nhamba yemasero asina chinhu muhuwandu, unogona kushandisa nhamba yebasa SCHETZ. Masero ane mavara, manhamba, zuva, nguva, uye maboolean values TRUE kana FALSE anoonekwa seasina chinhu.
Gadzirisa dambudziko rakasiyana, kureva kuverenga nhamba yemasero asina chinhu muExcel, unogona kushandisa basa racho COUNTBLANK:
COUNTIF()
nhamba basa COUNTIF inokubvumira kuverenga masero eExcel sheet sheet uchishandisa marudzi akasiyana emamiriro. Semuyenzaniso, fomula iri pazasi inodzosa nhamba yemaseru ane hunhu husina kunaka:
Iyi fomula inotevera inodzosa nhamba yemasero ane kukosha kwakakura kupfuura zviri mukati mesero A4.
COUNTIF inokubvumira kuverenga maseru ane mavara emavara. Semuenzaniso, fomula rinotevera rinodzosa nhamba yemaseru ane izwi rekuti "mavara" uye harina hanya.
Boolean basa mamiriro COUNTIF inogona kunge iine wildcards: * (asterisk) uye ? (mubvunzo wemubvunzo). Nyeredzi inomirira nhamba ipi zvayo yemavara asingadiwi, nepo mubvunzo wemubvunzo uchimirira mutsara mumwe chete.
Semuenzaniso, kuverenga nhamba yemasero ane mavara anotanga nebhii Н (nyaya isinganzwisisi), unogona kushandisa fomura inotevera:
Kana uchida kuverenga nhamba yemasero ane mavara mana chaiwo, saka shandisa iyi fomula:
basa COUNTIF inokubvumira kushandisa kunyange mafomula sechimiro. Semuenzaniso, kuverenga nhamba yemasero ane hukuru hukuru kupfuura avhareji, unogona kushandisa inotevera fomula:
Kana imwe mamiriro asina kukukwanira iwe, unogona kugara uchishandisa iyo nhamba basa COUNTIFS. Iri basa rinokutendera kuti uverenge masero muExcel anogutsa maviri kana anopfuura mamiriro kamwechete.
Semuenzaniso, iyo inotevera fomula inoverenga maseru ane hunhu hwakakura kupfuura zero asi asingasviki makumi mashanu:
basa COUNTIFS inobvumira maseru kuverengerwa pachishandiswa mamiriro И. Kana iwe uchida kuverenga huwandu nemamiriro acho OR, unofanira kushandisa akati wandei mabasa COUNTIF. Semuenzaniso, formula inotevera inoverenga masero anotanga nebhii А kana netsamba К:
Excel mabasa ekuverenga data anobatsira zvikuru uye anogona kuuya achibatsira munenge chero mamiriro ezvinhu. Ndinovimba kuti chidzidzo ichi chaburitsa zvese zvakavanzika zvemabasa kwauri. Check и COUNTIF, pamwe nevasonganiri vavo vepedyo - SCHETZ, COUNTBLANK и COUNTIFS. Dzoka kwatiri kakawanda. Zvese zvakanaka kwauri uye kubudirira mukudzidza Excel.
šta je ovo!