Ntchito yosavuta: pali ma cell angapo (tiyeni tinene A1: A10) pomwe wogwiritsa ntchito amalowetsa data kuchokera pa kiyibodi. Ndikofunikira kuwonetsetsa kuti zikhalidwe zonse zomwe zidalowetsedwa ndizosiyana, mwachitsanzo, kuletsa wogwiritsa ntchito kulowa mtengo ngati alipo kale pamitundu, mwachitsanzo, idayambitsidwa kale.
Sankhani ma cell angapo ndikudina batani Kutsimikiza kwa deta (Kutsimikizika kwa data) tsamba Deta (Tsiku). M'mitundu yakale - Excel 2003 ndi kale - tsegulani menyu Deta - Kutsimikizira (Deta - Kutsimikizika). Pa Advanced tabu magawo (Zikhazikiko) kuchokera pamndandanda wotsitsa Mtundu wa data (Lolani) sankhani njira Zina (Mwambo) ndipo lowetsani chilinganizo chotsatira pamzerewu chilinganizo (Fomula):
=COUNTIF($A$1:$A$10;A1)<=1
kapena mu Chingerezi =COUNTIF($A$1:$A$10;A1)<=1
Tanthauzo la ndondomekoyi ndi losavuta - limawerengera chiwerengero cha maselo mumtundu A1: A10 wofanana ndi zomwe zili mu selo A1. Kulowetsa kudzaloledwa kokha m'maselo omwe chiwerengerocho chimakhala chocheperapo kapena chofanana ndi 1. Komanso, mndandandawu umayikidwa mosamalitsa (ndi maumboni enieni okhala ndi zizindikiro za $), ndipo kutchulidwa kwa selo lamakono A1 ndilofanana. Chifukwa chake, cheke chofananira chidzachitidwa pa selo iliyonse yosankhidwa. Kuti mumalize chithunzicho, mutha kupita ku tabu pawindo ili Uthenga wolakwika (Chidziwitso Cholakwika)ndikulowetsa mawu omwe adzawonekere mukayesa kuyika zobwereza:
Ndizo zonse - dinani Chabwino ndikusangalala ndi zomwe ena amachita 🙂
Ubwino wa njirayi ndi kuphweka kwa kukhazikitsa, ndipo kuipa kwake ndikuti ndikosavuta kuletsa chitetezo chotere m'bokosi lomwelo la zokambirana kapena kukopera ndi kumata ma cell okhala ndi zobwereza mumitundu yathu. Palibe cholandirira chotsutsana ndi zidutswa. Kuti aletse zigawenga zotere, wogwiritsa ntchitoyo akuyenera kuletsa chitetezo chachinsinsi chachinsinsi ndikulemba macro apadera kuti aletse kukopera.
Koma njirayi idzateteza kwathunthu ku kulowetsa mwangozi kwa zobwereza.
- Kutulutsa zolemba zapadera pamndandanda
- Zobwereza zowunikira mitundu pamndandanda
- Kuyerekeza kwa mitundu iwiri ya data
- Chotsani zinthu zapadera pamndandanda uliwonse pogwiritsa ntchito chowonjezera cha PLEX.