Basa rakareruka: kune huwandu hwemasero (ngatitii A1: A10) uko mushandisi anopinda data kubva kukhibhodi. Izvo zvinodikanwa kuve nechokwadi chekusiyana kwezvose zvakapinzwa kukosha, kureva kudzivirira mushandisi kupinda kukosha kana yatovepo muhuwandu, kureva kuti yakaunzwa kare.
Sarudza huwandu hwemasero uye tinya bhatani Kugadziriswa kwedata (Data Validation) Tab Data (Zuva). Mune shanduro dzekare - Excel 2003 uye yapfuura - vhura menyu Data – Validation (Data - Validation). Pa Advanced tabo Parameters (Zvirongwa) kubva pakudonhedza pasi Rudzi rweData (Bvumira) sarudza sarudzo mwe (Tsika) uye isa fomura inotevera mumutsara fomura (Formula):
=COUNTIF($A$1:$A$10;A1)<=1
kana muChirungu =COUNTIF($A$1:$A$10;A1)<=1
Zvinorehwa neformula iyi zviri nyore - inoverenga nhamba yemasero muchikamu A1: A10 yakaenzana nezviri mukati mesero A1. Input ichabvumirwa chete mumasero iwayo apo nhamba inoguma iri pasi kana kuti yakaenzana ne 1. Uyezve, mutsara wakagadzirirwa zvakasimba (nezvinyorwa zvakakwana ne $ zviratidzo), uye chirevo chesero A1 iripo. Nokudaro, cheki yakafanana ichaitwa kune imwe neimwe yakasarudzwa sero. Kuti upedze mufananidzo, unogona kuenda kune tab iri pahwindo iri Error message (Error Alert)uye isa zvinyorwa zvinozoonekwa paunoyedza kuisa zvakapetwa:
Ndizvo chete - tinya OK uye unakirwe nemaitiro evamwe 🙂
Chakanakira nzira iyi kurerutsira kwekushandisa, uye chakashata ndechekuti zviri nyore kudzima dziviriro yakadaro mubhokisi renhaurirano rimwechete kana nekukopa nekunamira maseru ane duplicate mumhando yedu. Iko hakuna kugamuchirwa kunopikisa zvimedu. Kuti udzivise zviito zvehugandanga zvakadaro, mushandisi achafanirwa kugonesa kuchengetedzwa kwakakomba kwebepa re password uye kunyora yakakosha macro kuti atore kukopa.
Asi nzira iyi ichadzivirira zvachose kubva netsaona yekupinza yezvakapetwa.
- Kuburitsa zvakasarudzika kubva pane rondedzero
- Ruvara runoratidza zvakapetwa mune runyorwa
- Kuenzanisa kwezvikamu zviviri zve data
- Bvisa otomatiki zvinhu zvakasarudzika kubva kune chero runyorwa uchishandisa iyo PLEX yekuwedzera.