Zamkatimu
Kupanga vuto
Pali kuchuluka kwa data komwe zikhalidwe zina zimabwerezedwa kangapo:
Ntchitoyi ndikuwerengera kuchuluka kwapadera (osabwerezabwereza) pamitundu. Mu chitsanzo pamwambapa, n'zosavuta kuona kuti zosankha zinayi zokha zimatchulidwa.
Tiyeni tione njira zingapo zothetsera vutoli.
Njira 1. Ngati palibe maselo opanda kanthu
Ngati mukutsimikiza kuti kulibe ma cell opanda kanthu pagulu loyambira, mutha kugwiritsa ntchito njira yachidule komanso yokongola:
Musaiwale kuti mulowetse ngati ndondomeko yowonjezera, mwachitsanzo, akanikizire mutalowetsa fomuyi osati Lowani, koma kuphatikiza Ctrl + Shift + Enter.
Mwaukadaulo, fomula iyi imabwerezabwereza m'maselo onse amgululi ndikuwerengera chinthu chilichonse kuchuluka kwa zomwe zimachitika munjirayo pogwiritsa ntchito ntchitoyi. COUNTIF (COUNTIF). Ngati tiyimira izi ngati gawo lowonjezera, ndiye kuti zitha kuwoneka motere:
Ndiye zigawozo zimawerengedwa 1/Chiwerengero cha zochitika pa chinthu chilichonse ndipo zonse zaphatikizidwa, zomwe zingatipatse kuchuluka kwa zinthu zapadera:
Njira 2. Ngati pali maselo opanda kanthu
Ngati pali ma cell opanda kanthu pamndandanda, ndiye kuti muyenera kusintha pang'ono fomulayo powonjezera cheke pama cell opanda kanthu (kupanda kutero tipeza cholakwika chagawidwe ndi 0 mugawo):
Ndichoncho.
- Momwe mungachotsere zinthu zapadera kuchokera pagulu ndikuchotsa zobwereza
- Momwe mungawonetsere zobwerezedwa pamndandanda wokhala ndi mtundu
- Momwe mungafananizire magawo awiri obwereza
- Chotsani zolemba zapadera patebulo ndi gawo lomwe mwapatsidwa pogwiritsa ntchito chowonjezera cha PLEX