Okuqukethwe
Ukuze uthole amanani eseli atholakala ezimpambanweni zekholomu kanye nomugqa ohlwini lwethebula ku-Microsoft Office Excel, kufanele usebenzise umsebenzi othi “INDEX”, kanye nomsizi othi “SEARCH”. Ukuthola inani kulungu elifanayo kuyadingeka lapho umsebenzisi esebenza netafula elikhulu, futhi udinga "ukudonsa" uchungechunge lwedatha. Lesi sihloko sizobheka i-algorithm enemininingwane yokusebenzisa umsebenzi we-"INDEX" ukucinga amanani ohlwini.
Irekhoda umsebenzi we-"INDEX".
I-opharetha ye-array enjalo ibhalwe kanje: =INDEX(uhlu; inombolo yomugqa; inombolo yekholomu). Esikhundleni samagama kubakaki, izinombolo ezihambisanayo zamaseli kuthebula lokuqala ziyakhonjiswa.
Irekhoda umsebenzi othi "MATCH".
Lona umsizi ka-opharetha womsebenzi wokuqala, ozophinde usetshenziswe lapho ubheka amanani ohlwini. Irekhodi layo ku-Excel libukeka kanje: =MATCH(inani elizotholwa; uhlu lwethebula; uhlobo lokufanisa).
Nakani! Lapho ubhala izimpikiswano zomsebenzi we-INDEX, inombolo yekholomu ingokuzithandela.
Ungalithola kanjani inani ohlwini
Ukuze uqonde isihloko, i-algorithm yokwenza umsebenzi kufanele icatshangelwe kusetshenziswa isibonelo esithile. Masenze itafula lama-oda ku-Excel usuku olulodwa, lapho kuzoba khona amakholomu: “inombolo ye-oda”, “Ikhasimende”, “Umkhiqizo”, “Ubuningi”, “Inani leyunithi”, “Inani”. Udinga ukuthola inani ohlwini, okungukuthi dala ikhadi le-oda lekhasimende ngalinye ukuze ukwazi ukuthola ulwazi ngendlela ecindezelwe kumaseli ethebula lokuqala.
Ukuze wenze lokhu, udinga ukwenza uchungechunge lwezenzo ngokuya nge-algorithm:
- Dala ikhadi le-oda lekhasimende.
- Ngomugqa wokuqala wekhadi, udinga ukudala uhlu lokudonsela phansi lapho amagama amaklayenti avela ohlwini oluyinhloko azobhalwa khona. Kamuva, ngokukhetha igama elithile, umsebenzisi uzobona ulwazi olufushane kulo, oluzoboniswa kweminye imigqa yekhadi le-oda.
- Beka ikhesa yegundane emgqeni wokuqala wekhadi bese ufaka ingxenye ethi “Idatha” phezulu kumenyu enkulu yohlelo.
- Chofoza inkinobho ethi "Ukuqinisekisa Idatha".
- Ewindini elivelayo, kunkambu ethi "Uhlobo lwedatha", khetha inketho ethi "Uhlu", bese ukhetha ububanzi bamaseli ohlelo lwangempela njengomthombo, lapho kubhaliswa khona uhlu lwawo wonke amaklayenti.
- Umcibisholo uzovela kwesokudla seseli kukholamu yokuqala yekhadi. Uma uchofoza kukho, ungabona uhlu lwawo wonke amaklayenti. Lapha udinga ukukhetha noma yiliphi iklayenti.
- Emgqeni “inombolo ye-oda” bhala umsebenzi «=INDEX(», bese uchofoza kusithonjana esithi “fx” eduze kwebha yefomula ye-Excel.
- Kumenyu ye-Function Wizard evulayo, khetha ifomu lamalungu afanayo lomsebenzi we-“INDEX” ohlwini bese uchofoza okuthi “KULUNGILE”.
- Iwindi elithi "Izimpikiswano Zomsebenzi" lizovuleka, lapho udinga ukugcwalisa yonke imigqa, ekhombisa ububanzi obuhambisanayo bamaseli.
- Okokuqala udinga uchofoze isithonjana esiphambene nenkambu ethi “Array” bese ukhetha ipuleti lonke langempela kanye nesihloko.
- Esigabeni "Inombolo yomugqa" udinga ukugcwalisa umsebenzi othi "MATCH". Endaweni yokuqala kubakaki, njengengxabano, sibonisa igama leklayenti elikhethwe ekhadini le-oda. Njengokuphikisana kwesibili komsebenzi othi “MATCH”, udinga ukucacisa lonke uhla lwamakhasimende ohlwini lwangempela lwethebula. Esikhundleni sempikiswano yesithathu, kufanele ubhale inombolo 0, ngoba izobheka okufana ncamashi.
Kubalulekile! Ngemva kokugcwalisa isici ngasinye somsebenzi othi “MATCH”, uzodinga ukucindezela inkinobho ethi “F4” ukuze ulengise izimpawu zedola phambi komlingiswa ngamunye kungxabano. Lokhu kuzovumela ifomula ukuthi "ingaphumi" ngesikhathi sokwenza.
- Emgqeni othi “Inombolo Yekholomu” phinda ubhale umsebenzi osizayo othi “FANISA” nezimpikiswano ezifanele.
- Njengempikiswano yokuqala yomsebenzi, kufanele ucacise iseli elingenalutho emugqeni othi “Umkhiqizo” ekhadini le-oda. Ngesikhathi esifanayo, akusadingeki ukulenga izimpawu zamadola ezingxabano, ngoba ingxabano oyifunayo kufanele "intante".
- Ukugcwalisa impikiswano yesibili yomsebenzi othi "MATCH", udinga ukukhetha inhlokweni yohlu lomthombo, bese ucindezela inkinobho ethi "F4" ukuze ulungise izinhlamvu.
- Njengempikiswano yokugcina, kufanele ubhale u-0, uvale ubakaki bese uchofoza okuthi “KULUNGILE” ezansi kwebhokisi elithi “Izimpikiswano Zomsebenzi”. Kulesi simo, inombolo engu-0 ifana ncamashi.
- Hlola umphumela. Ngemva kokwenza izenzo ezinde kangaka, inombolo ehambisana neklayenti elikhethiwe kufanele iboniswe kulayini "inombolo ye-oda".
- Esigabeni sokugcina, ifomula izodinga ukwelulelwa kuwo wonke amaseli ekhadi le-oda kuze kube sekugcineni ukuze kugcwaliswe imigqa esele.
Ulwazi Olwengeziwe! Uma iklayenti likhethwa ohlwini oluya phansi lwekhadi le-oda, lonke ulwazi olukulo muntu luzoboniswa emigqeni esele yamalungu afanayo.
Isiphetho
Ngakho-ke, ukuthola inani elidingekayo ohlwini lwe-Microsoft Office Excel, umsebenzisi kuzodingeka enze umsebenzi omningi. Ngenxa yalokho, kufanele kutholwe ipuleti ledatha elincane, elibonisa ulwazi olucindezelwe lwepharamitha ngayinye ohlwini lwangempela. Indlela yokucinga amanani ngezithombe ezihambisanayo ixoxiwe ngokuningiliziwe ngenhla.