Ungalithola kanjani inani ohlwini ku-Excel

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.

Ungalithola kanjani inani ohlwini ku-Excel
Ukubukeka kwepuleti elihlanganisiwe

Ukuze wenze lokhu, udinga ukwenza uchungechunge lwezenzo ngokuya nge-algorithm:

  1. Dala ikhadi le-oda lekhasimende.
Ungalithola kanjani inani ohlwini ku-Excel
Ikhadi le-oda lekhasimende
  1. 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.
  2. Beka ikhesa yegundane emgqeni wokuqala wekhadi bese ufaka ingxenye ethi “Idatha” phezulu kumenyu enkulu yohlelo.
  3. Chofoza inkinobho ethi "Ukuqinisekisa Idatha".
  4. Ewindini elivelayo, kunkambu ethi "Uhlobo lwedatha", khetha inketho ethi "Uhlu", bese ukhetha ububanzi bamaseli ohlelo lwangempela njengomthombo, lapho kubhaliswa khona uhlu lwawo wonke amaklayenti.
Ungalithola kanjani inani ohlwini ku-Excel
Izenzo ezidingekayo efasiteleni elithi “Hlola amanani okokufaka”. Lapha sikhetha inketho ethi "Uhlu" futhi sibonise ububanzi bawo wonke amaklayenti
  1. Umcibisholo uzovela kwesokudla seseli kukholamu yokuqala yekhadi. Uma uchofoza kukho, ungabona uhlu lwawo wonke amaklayenti. Lapha udinga ukukhetha noma yiliphi iklayenti.
Ungalithola kanjani inani ohlwini ku-Excel
Uhlu lwamaklayenti oluzovela emugqeni wokuqala wekhadi ngemva kokwenza ukukhohlisa kwangaphambilini
  1. Emgqeni “inombolo ye-oda” bhala umsebenzi «=INDEX(», bese uchofoza kusithonjana esithi “fx” eduze kwebha yefomula ye-Excel.
  2. Kumenyu ye-Function Wizard evulayo, khetha ifomu lamalungu afanayo lomsebenzi we-“INDEX” ohlwini bese uchofoza okuthi “KULUNGILE”.
Ungalithola kanjani inani ohlwini ku-Excel
Ukukhetha umumo wamalungu afanayo womsebenzi we-"INDEX".
  1. Iwindi elithi "Izimpikiswano Zomsebenzi" lizovuleka, lapho udinga ukugcwalisa yonke imigqa, ekhombisa ububanzi obuhambisanayo bamaseli.
Ungalithola kanjani inani ohlwini ku-Excel
Ukuvela kwewindi elithi "Izimpikiswano Zomsebenzi".
  1. Okokuqala udinga uchofoze isithonjana esiphambene nenkambu ethi “Array” bese ukhetha ipuleti lonke langempela kanye nesihloko.
Ungalithola kanjani inani ohlwini ku-Excel
Ukugcwalisa umugqa othi “Array”. Lapha udinga ukuchofoza isithonjana ekupheleni kwenkundla bese ukhetha ipuleti lokuqala
  1. 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.
Ungalithola kanjani inani ohlwini ku-Excel
Ukugcwalisa inkambu yenombolo yolayini kumenyu yezimpikiswano zomsebenzi. I-opharetha ye-MATCH isetshenziswa lapha.

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.

  1. Emgqeni othi “Inombolo Yekholomu” phinda ubhale umsebenzi osizayo othi “FANISA” nezimpikiswano ezifanele.
  2. 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".
  3. Ukugcwalisa impikiswano yesibili yomsebenzi othi "MATCH", udinga ukukhetha inhlokweni yohlu lomthombo, bese ucindezela inkinobho ethi "F4" ukuze ulungise izinhlamvu.
  4. Njengempikiswano yokugcina, kufanele ubhale u-0, uvale ubakaki bese uchofoza okuthi “KULUNGILE” ezansi kwebhokisi elithi “Izimpikiswano Zomsebenzi”. Kulesi simo, inombolo engu-0 ifana ncamashi.
Ungalithola kanjani inani ohlwini ku-Excel
Gcwalisa inkambu ethi “Inombolo Yekholomu”. Lapha, futhi, kufanele ucacise zonke izimpikiswano zomsebenzi othi “MATCH”, ugqamisa ububanzi obuhambisanayo bamaseli kuhlu lwethebula. 0 icaciswe njengengxabano yokugcina
  1. Hlola umphumela. Ngemva kokwenza izenzo ezinde kangaka, inombolo ehambisana neklayenti elikhethiwe kufanele iboniswe kulayini "inombolo ye-oda".
Ungalithola kanjani inani ohlwini ku-Excel
Umphumela wokugcina. Inani elihambisanayo elivela ohlwini lwangempela lwethebula livele endaweni “yenombolo ye-oda”
  1. Esigabeni sokugcina, ifomula izodinga ukwelulelwa kuwo wonke amaseli ekhadi le-oda kuze kube sekugcineni ukuze kugcwaliswe imigqa esele.
Ungalithola kanjani inani ohlwini ku-Excel
Ukwelula ifomula kuyo yonke imigqa yethebula. Uhlu olugcwele ngokugcwele. Idatha izoshintsha lapho kukhethwa elinye iklayenti

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.

shiya impendulo