Umsebenzi olula: kukhona uhla lwamaseli (ake sithi A1:A10) lapho umsebenzisi afaka khona idatha esuka kukhibhodi. Kuyadingeka ukuqinisekisa ukuhluka kwawo wonke amanani afakiwe, okungukuthi ukuvimbela umsebenzisi ukuthi angangeni ivelu uma selivele likhona ebangeni, okungukuthi yethulwe ngaphambi kwesikhathi.
Khetha uhla lwamaseli bese uchofoza inkinobho Ukuqinisekiswa kwedatha (Ukuqinisekiswa Kwedatha) ithebhu Idatha (Usuku). Ezinguqulweni ezindala - i-Excel 2003 nangaphambili - vula imenyu Idatha - Ukuqinisekisa (Idatha - Ukuqinisekisa). Kuthebhu ethuthukisiwe Amapharamitha (Izilungiselelo) ohlwini lokudonsela phansi Uhlobo lwedatha (Vumela) khetha inketho Izincwajana zemininingwane (Ngokwezifiso) bese ufaka ifomula elandelayo emgqeni Formula (Ifomula):
=COUNTIF($A$1:$10;A1)<=1
noma ngesiNgisi =COUNTIF($A$1:$A$10;A1)<=1
Incazelo yale fomula ilula - ibala inani lamaseli kububanzi A1:A10 elilingana nokuqukethwe kweseli A1. Okokufaka kuzovunyelwa kuphela kulawo maseli lapho inombolo ewumphumela ingaphansi noma ilingana no-1. Ngaphezu kwalokho, ububanzi bumiswe ngokuqinile (ngezithenjwa eziphelele ezinezimpawu ezingu-$), futhi ireferensi yeseli A1 yamanje ihlobene. Ngakho, ukuhlolwa okufanayo kuzokwenziwa kuseli ngalinye elikhethiwe. Ukuze uqedele isithombe, ungaya kuthebhu kuleli windi Umlayezo wephutha (Isixwayiso Sephutha)bese ufaka umbhalo ozovela uma uzama ukufaka izimpinda:
Yilokho kuphela – chofoza okuthi KULUNGILE futhi ujabulele ukusabela kwabanye 🙂
Inzuzo yale ndlela ukusebenziseka kalula, futhi okubi ukuthi kulula ukukhubaza ukuvikela okunjalo ebhokisini lengxoxo elifanayo noma ngokukopisha nokunamathisela amaseli anezimpinda kububanzi bethu. Akukho ukwamukela ngokumelene ne-scrap. Ukuze uvimbele izenzo zobuphekula ezinjalo, umsebenzisi kuzodingeka anikeze amandla ukuvikela okubucayi kakade kweshidi lephasiwedi futhi abhale i-macro ekhethekile ukuze avimbele ukukopishwa.
Kodwa le ndlela izovikela ngokuphelele ekufakeni ngephutha kwezimpinda.
- Ikhipha okufakiwe okuhlukile ohlwini
- Umbala ogqamisa izimpinda ohlwini
- Ukuqhathaniswa kobubanzi bedatha obubili
- Khipha ngokuzenzakalelayo izinto ezihlukile kunoma yiluphi uhlu usebenzisa isengezo se-PLEX.