Lapho wenza imisebenzi e-Excel, kungadingeka ukuthi ususe amaseli angenalutho. Imvamisa iyinto engadingekile futhi inyusa kuphela inani lamalungu onke edatha, adida umsebenzisi. Sizochaza izindlela zokususa ngokushesha izinto ezingenalutho.
I-Deletion Algorithms
Okokuqala, udinga ukuthola ukuthi, kungenzeka yini ukuthi ususe amangqamuzana angenalutho kuhlu noma etafuleni elithile? Le nqubo iholela ekukhetheni idatha, futhi lokhu kude kuvunyelwe njalo. Eqinisweni, izinto zingasuswa kuphela ezimweni ezimbili:
- Uma umugqa (ikholamu) awunalutho ngokuphelele (kumatafula);
- Uma amaseli emugqeni nekholomu angaxhumekile ngokunengqondo nomunye (ngama-arrows).
Uma kunamaseli ambalwa angenalutho, angasuswa ngokuphelele kusetshenziswa indlela ejwayelekile yokususa ibhukwana. Kepha, uma kunenani elikhulu lezinto ezinjalo ezingafakwanga, khona-ke kuleli cala, le nqubo idinga ukuzenzakalelayo.
Indlela 1: khetha amaqembu weseli
Indlela elula yokukhipha izinto ezingenalutho ukusebenzisa ithuluzi lokukhetha iqembu leseli.
- Sikhetha ibanga eshidini esizokwenza ngalo ukusebenza nokusesha izinto ezingenalutho. Chofoza ukhiye wokusebenza kukhibhodi F5.
- Kubizwa iwindi elincane Inguquko. Chofoza inkinobho kuyo "Khetha ...".
- Kuvulwa iwindi elilandelayo - "Ukukhetha amaqembu weseli". Hlela ukushintshana ukuze ubeke kulo Amaseli angenalutho. Chofoza inkinobho. "Kulungile".
- Njengoba ukwazi ukubona, zonke izinto ezingenalutho zohlu olubekiwe zikhethiwe. Sichofoza noma ikuphi kubo ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe eqala, chofoza entweni "Susa ...".
- Kuvulwa iwindi elincane lapho kufanele ukhethe khona okufanele kususwe. Shiya izilungiselelo ezizenzakalelayo - "Amaseli ngokushintshela phezulu". Chofoza inkinobho "Kulungile".
Ngemuva kwalokhu kwenziwa, zonke izinto ezingenalutho ngaphakathi kwebanga elicacisiwe zizosuswa.
Indlela 2: ukufometha okunemibandela nokuhlunga
Ungasusa namaseli angenalutho ngokusebenzisa ukufomatha okunemibandela nokuhlunga kwedatha okwalandela. Le ndlela iyinkimbinkimbi kakhulu kunangaphambili, kepha noma kunjalo, abanye abasebenzisi bayayithanda. Ngaphezu kwalokho, kufanele wenze ukubhuka ngokushesha ukuthi le ndlela ifaneleka kuphela uma amanani akukholamu efanayo futhi engenayo ifomula.
- Khetha ibanga esizolisebenzisa. Ukuba kuthebhu "Ikhaya"chofoza isithonjana Ukufomatha okunemibandela, yona, ibekwe endaweni yebhulashi yamathuluzi Izitayela. Iya entweni esohlwini oluvulayo. Imithetho Yokukhetha Iseli. Kuluhlu lwezenzo ezivela, khetha isikhundla "Okuningi ...".
- Iwindi lokufometha okunemibandela liyavula. Faka inombolo kunkambu yesobunxele "0". Ensimini efanele, khetha noma imuphi umbala, kepha ungashiya izilungiselelo ezizenzakalelayo. Chofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, wonke amaseli ebangeni elishiwo lapho amanani atholakala khona aqokonyiswa ngombala okhethiwe, futhi angenalutho ahlala amhlophe. Futhi, gqamisa uhla lwethu. Kuthebhu efanayo "Ikhaya" chofoza inkinobho Hlunga nesihlungietholakala eqenjini "Ukuhlela". Kumenyu evulayo, chofoza inkinobho "Hlunga".
- Ngemuva kwalezi zenzo, njengoba sibona, isithombe esifanekisela ukuhlunga savela engxenyeni ephezulu yekholamu. Qhafaza kuwo. Kuluhlu oluvulayo, iya ku "Hlunga ngombala". Ngaphezu kwalokho eqenjini "Hlunga ngombala weseli" khetha umbala wokuthi ukukhetha kuye kwenzeka ngenxa yokufomatha okunemibandela.
Ungenza futhi okuhlukile. Chofoza isithonjana sokuhlunga. Kumenyu evelayo, ungahloli isikhundla "Akunalutho". Ngemuva kwalokho chofoza inkinobho "Kulungile".
- Kunoma yikuphi ukukhetha okukhonjiswe esigabeni esedlule, izinto ezingenalutho zizofihlwa. Khetha ibanga lamaseli asele. Ithebhu "Ikhaya" kwibhlokhi yezilungiselelo Ibhodi yokunamathisela chofoza inkinobho Kopisha.
- Bese ukhetha noma iyiphi indawo engenalutho ngokufana noma kwelinye iphepha. Qhafaza kwesokudla. Uhlu lwesenzo lokuqukethwe oluvela, kukhetho lokufaka, khetha "Amanani".
- Njengoba ukwazi ukubona, imininingwane yafakwa ngaphandle kokufomatha. Manje usususa ibanga eliyinhloko, futhi endaweni yalo ufake lelo esilitholile ngenqubo engenhla, noma ungaqhubeka nokusebenza nedatha endaweni entsha. Konke kuncike kwimisebenzi ethile kanye nezinto eziza kuqala kumsebenzisi.
Isifundo: Ukufomatha okunemibandela ku-Excel
Isifundo: Hlunga futhi uhlunge idatha ku-Excel
Indlela 3: ukusebenzisa ifomula eyinkimbinkimbi
Ngaphezu kwalokho, ungasusa amaseli angenalutho kumalungu afanayo ngokusebenzisa ifomula eyinkimbinkimbi equkethe imisebenzi eminingana.
- Okokuqala, sizodinga ukuthi sibeke igama ebangeni eliguqukayo. Khetha indawo, chofoza kwesokudla. Kumenyu evuliwe, khetha "Nikeza igama ...".
- Kuvula iwindi. Ensimini "Igama" nikeza noma yiliphi igama elifanele. Isimo esikhulu ukuthi akufanele kube nezikhala. Isibonelo, sabela igama ebangeni. "C_empty". Azikho ezinye izinguquko ezidingekayo kulelo windi. Chofoza inkinobho "Kulungile".
- Khetha noma ikuphi eshidi ngokulingana nobubanzi beseli elingenalutho. Ngokufanayo, sichofoza kwesokudla bese, sibize imenyu yokuqukethwe, siye entweni "Nikeza igama ...".
- Ewindini elivulayo, njengasesikhathini esedlule, sinika noma yiliphi igama kule ndawo. Sanquma ukumnika igama "No_empty".
- Qhafaza kabili inkinobho yegundane kwesobunxele esitokisini sokuqala sebanga elinemibandela "No_empty" (ingaba negama elihlukile kuwe). Sifaka kuyo ifomula lohlobo olulandelayo:
= IF (LINE () - LINE (Bila_empty) +1> STRING (With_empty) -Count VOIDs (With_empty); ""; (С_empty))); STRING () - STRING (Ngaphandle_okukhulu) +1); COLUMN (С_empty); 4))Njengoba le kuyifomula yamalungu afanayo, ukubonisa ukubalwa esikrinini, udinga ukucindezela inhlanganisela yokhiye I-Ctrl + Shift + Faka, esikhundleni sokucindezela inkinobho evamile Ngena.
- Kepha, njengoba sibona, yigumbi elilodwa kuphela elaligcwalisiwe. Ukuze ugcwalise okusele, udinga ukukopisha ifomula kulo lonke uhla. Lokhu kungenziwa kusetshenziswa umaka wokugcwalisa. Sibeka isikhombisi ekhoneni elingezansi kwesokudla kweseli eliqukethe umsebenzi oyinkimbinkimbi. Isikhombisi kufanele siguqulwe saba yisiphambano. Bamba inkinobho yegundane kwesobunxele futhi uyihudulele phansi ekugcineni kobubanzi "No_empty".
- Njengoba ubona, ngemuva kwalesi senzo sinebanga lapho amaseli agcwele atholakala khona ngokulandelana. Kepha ngeke sikwazi ukwenza imisebenzi ehlukahlukene ngale datha, ngoba ihlobene nefomula yamalungu afanayo. Khetha lonke uhla. "No_empty". Chofoza inkinobho Kopishaelibekwe kuthebhu "Ikhaya" ebhokisini lamathuluzi Ibhodi yokunamathisela.
- Ngemuva kwalokho sikhetha uhlu lokuqala lwedatha. Sichofoza inkinobho yegundane elifanele. Uhlu oluvuleka eqenjini Faka Izinketho chofoza isithonjana "Amanani".
- Ngemuva kwalezi zenzo, imininingwane izofakwa endaweni yasekuqaleni yendawo yayo ngohlu oluqinile ngaphandle kwamaseli angenalutho. Uma kufiswa, uhlu oluqukethe ifomula manje selingasuswa.
Isifundo: Ungayibiza kanjani iseli e-Excel
Kunezindlela eziningi zokususa izinto ezingenalutho ku-Microsoft Excel. Inketho yokukhetha amaqembu amaseli kulula kakhulu futhi okusheshayo. Kepha izimo azifani. Ngakho-ke, njengezindlela ezengeziwe, kungenzeka ukusebenzisa izinketho nge-filtration kanye nokusebenzisa ifomula eyinkimbinkimbi.
