Aiki mai sauƙi: akwai kewayon sel (bari mu ce A1: A10) inda mai amfani ya shigar da bayanai daga maballin. Wajibi ne a tabbatar da keɓancewar duk ƙimar da aka shigar, watau hana mai amfani daga shigar da ƙima idan ya riga ya kasance a cikin kewayon, watau an gabatar da shi a baya.
Zaɓi kewayon sel kuma danna maɓallin Ingancin bayanai (Tabbacin Bayanai) tab data (Kwanan wata). A cikin tsofaffin sigogin - Excel 2003 da baya - buɗe menu Bayanai - Tabbatarwa (Bayanai - Tabbatarwa). A kan Babba shafin Siga (Saituna) daga drop down list Nau'in bayanai (Izinin) zaɓi zaɓi Other (Na al'ada) kuma shigar da dabara mai zuwa a cikin layi formula (Formula):
= COUNTIF ($1: $10;A1) <= 1
ko a Turanci = COUNTIF($A$1:$A$10;A1)=1
Ma'anar wannan tsari yana da sauƙi - yana ƙidaya adadin sel a cikin kewayon A1: A10 daidai da abinda ke cikin tantanin halitta A1. Za a ba da izinin shigarwa kawai a cikin waɗancan sel inda adadin da aka samu bai kai ko daidai da 1. Bugu da ƙari, an saita kewayon sosai (ta cikakkun bayanai tare da alamun $), kuma nuni ga tantanin halitta A1 na yanzu dangi ne. Don haka, za a yi irin wannan cak ga kowane tantanin halitta da aka zaɓa. Don kammala hoton, zaku iya zuwa shafin a wannan taga Kuskuren saƙo (Fadar Kuskure)kuma shigar da rubutun da zai bayyana lokacin da kake ƙoƙarin shigar da kwafi:
Wannan ke nan - danna Ok kuma ku ji daɗin martanin wasu 🙂
Amfanin wannan hanyar shine sauƙin aiwatarwa, kuma rashin amfani shine yana da sauƙin kashe irin wannan kariya a cikin akwatin maganganu guda ɗaya ko ta kwafi da liƙa sel tare da kwafi a cikin kewayon mu. Babu liyafar adawa da tarkace. Don hana irin waɗannan ayyukan ta'addanci, mai amfani dole ne ya ba da damar kariya mai tsanani na takaddar kalmar sirri kuma ya rubuta macro na musamman don hana kwafi.
Amma wannan hanya za ta kare gaba ɗaya daga shigar da kwafi na bazata.
- Ciro abubuwan shigarwa na musamman daga jeri
- Launi mai nuna kwafi a cikin jeri
- Kwatanta kewayon bayanai guda biyu
- Cire abubuwa na musamman ta atomatik daga kowane jeri ta amfani da ƙari na PLEX.