Muva nje, sixoxe ngokusetshenziswa komsebenzi we-FILTER.XML ukungenisa idatha ye-XML ku-inthanethi - umsebenzi oyinhloko lo msebenzi, empeleni, ohloselwe wona. Nokho, endleleni, kuvele okunye ukusetshenziswa okungalindelekile nokuhle kwalo msebenzi - ukuhlukanisa ngokushesha umbhalo onamathelayo ube amaseli.
Ake sithi sinekholomu yedatha efana nalena:
Yiqiniso, ukuze kube lula, ngingathanda ukuyihlukanisa ngamakholomu ahlukene: igama lenkampani, idolobha, umgwaqo, indlu. Ungakwenza lokhu ngezindlela eziningi ezahlukene:
- Sebenzisa Umbhalo ngamakholomu kusuka kuthebhu Idatha (Idatha — Umbhalo kumakholomu) uhambe izinyathelo ezintathu Umhlaziyi wombhalo. Kodwa uma idatha ishintsha kusasa, kuzodingeka ukuthi uphinde yonke inqubo futhi.
- Layisha le datha kokuthi Umbuzo Wamandla futhi uyihlukanise lapho, bese uyilayisha futhi eshidini, bese ubuyekeza umbuzo lapho idatha ishintsha (osekulula kakade).
- Uma udinga ukubuyekeza ku-fly, ungabhala amafomula ayinkimbinkimbi kakhulu ukuze uthole okhefana futhi ukhiphe umbhalo phakathi kwawo.
Futhi ungakwenza ngobuhle obungaphezulu futhi usebenzise umsebenzi we-FILTER.XML, kodwa ihlobene ngani nakho?
Umsebenzi we-FILTER.XML uthola njengengxabano yawo yokuqala ikhodi ye-XML — umbhalo omakwe ngomaka abakhethekile nezibaluli, bese uwuhlukanisela ezingxenyeni zawo, ukhipha izingcezu zedatha esizidingayo. Ikhodi ye-XML ivamise ukubukeka kanjena:
Ku-XML, into ngayinye yedatha kufanele ifakwe kumathegi. Umaka umbhalo othile (esibonelweni esingenhla ungumphathi, igama, inzuzo) ofakwe kubakaki be-engeli. Amathegi ahlala efika ngababili – ukuvuleka nokuvala (ngesiklebhu esifakwe ekuqaleni).
Umsebenzi we-FILTER.XML ungakhipha kalula okuqukethwe kwabo bonke omaka esibadingayo, isibonelo, amagama abo bonke abaphathi, futhi (okubaluleke kakhulu) babonise bonke ngesikhathi esisodwa ohlwini olulodwa. Ngakho-ke umsebenzi wethu ukungeza omaka embhalweni womthombo, ukuwuguqulela kukhodi ye-XML elungele ukuhlaziya okulandelayo ngomsebenzi we-FILTER.XML.
Uma sithatha ikheli lokuqala ohlwini lwethu njengesibonelo, sizodinga ukuliguqula libe yilokhu kwakhiwa:
Ngishayele ukuvulwa komhlaba wonke nokuvala ithegi yombhalo t, kanye namathegi afaka i-elementi ngayinye s., kodwa ungasebenzisa noma yiziphi ezinye izincazelo - akunandaba.
Uma sisusa ama-indenti kanye nokunqamuka komugqa kule khodi - ngokuphelele, ngendlela, ngokuzikhethela futhi sengezwe kuphela ukuze kucace, khona-ke konke lokhu kuzophenduka umugqa:
Futhi isivele itholakale kalula ekhelini lomthombo ngokufaka okhefana kuwo ngamathegi ambalwa. usebenzisa umsebenzi I-SUBSTITUTE (SUBSTITUTE) nokunamathisela ngophawu & ekuqaleni nasekupheleni kwamathegi okuvula nawokuvala:
Ukwandisa ububanzi obuwumphumela ngokuvundlile, sisebenzisa umsebenzi ojwayelekile I-TRANSP (TRANSPOSE), sigoqa ifomula yethu ngayo:
Isici esibalulekile salo mklamo wonke ukuthi enguqulweni entsha ye-Office 2021 ne-Office 365 esekelwa ama-array ashintshashintshayo, akukho ukuthinta okukhethekile okudingekayo ukuze kufakwe - vele ufake bese uchofoza ku- Faka - ifomula ngokwayo ithatha inani lamaseli ayidingayo futhi yonke into isebenza nge-bang. Ezinguqulweni ezedlule, lapho bekungakabi khona ama-array aguqukayo, uzodinga kuqala ukhethe inani elanele lamaseli angenalutho ngaphambi kokufaka ifomula (ungakwazi ngemajini), futhi ngemuva kokudala ifomula, cindezela isinqamuleli sekhibhodi. Ctrl+Shift+Fakaukuyifaka njengefomula yamalungu afanayo.
Iqhinga elifanayo lingasetshenziswa lapho kuhlukaniswa umbhalo ohlanganiswe ndawonye ube yiseli elilodwa ngokuhlukana komugqa:
Umehluko kuphela ngesibonelo sangaphambilini ukuthi esikhundleni sikakhefana, lapha sishintsha uhlamvu olungabonakali lwe-Alt + Enter lwekhefu, olungacaciswa kufomula kusetshenziswa umsebenzi we-CHAR ngekhodi 10.
- Ubuqili bokusebenza ngokunqamuka komugqa (Alt + Enter) ku-Excel
- Hlukanisa umbhalo ngamakholomu ku-Excel
- Ishintsha umbhalo ngokuthi SUBSTITUTE