Indlela yokusebenzisa umsebenzi we-DGET kwi-Excel

01 ngo 01

Fumana iirekhodi ezicacileyo kwi-Excel Database

Umsebenzi we-DGET ngenye yemisebenzi yedatha ye-Excel. Leli qela lemisebenzi lenzelwe ukwenza kube lula ukufingqa ulwazi ukusuka kwiibhuli ezikulu zeedatha. Benza oku ngokubuyisela ulwazi oluthile olusekelwe kwelinye iqela okanye ngaphezulu ekhethwe ngumsebenzisi.

Umsebenzi we-DGET ungasetyenziselwa ukubuyisela enye intsimi yedata ukusuka kwikholam yedatha ehambelana nezimo ozichaza.

I-DGET ifana nomsebenzi weVLOOKUP ongasetyenziselwa ukubuyela kwiindawo ezilodwa zeedatha.

I-DGET yesiXhosa kunye neeArguments

I- syntax yomsebenzi we-DGET:

= IDGET (idatha, indawo, imigaqo)

Yonke imisebenzi yeenkcukacha zedatha inezizathu ezifanayo ezintathu:

• I-Database : (efunekayo) Icacisa uluhlu lweenkcazo zeeseli eziqulethe database. Amagama endle kufuneka afakwe kwibala.
• Intsimi : (efunekayo) Ubonisa ukuba yeyiphi ikoruba okanye intsimi ekufuneka isetyenziswe ngumsebenzi kubalo. Faka ingxabano okanye ngokufaka ifom yegama (njenge- #Orders) okanye faka inombolo yekholomu (njenge-3).
• Iimpawu : (ezifunekayo) Ukuluhlu uluhlu lweeseli eziqulethe iimeko ezichazwe ngumsebenzisi. Uluhlu kufuneka lubandakanye ubuncinane igama elinye lentsimi ukusuka kwisiseko sedatha kwaye ubuncinane enye enye yeselferensi yesalathisi ebonisa imeko ukuba ihlolwe ngumsebenzi.

Umzekelo Ukusebenzisa Umsebenzi we-DGET ye-Excel: Ukulingana neCandelo elilodwa

Lo mzekelo uza kusebenzisa i- DGET ukufumana inani leemali zokuthengisa ezibekwe yintengiso yerhwebo enyangeni enikwe.

Ukufaka i-Tutorial Data

Qaphela: Uqeqesho alubandakanyi amanyathelo okufomatha.

1. Faka itafile yedatha kwiiseli D1 ukuya kwi-F13
2. Shiya iselula e-E5 ingenanto; le yilapho ifom ye-DGET iya kuba khona
3. Amagama endle kwiiseli ze-D2 ukuya ku-F2 ziya kusetyenziswa njengenxalenye yempikiswano yeCriteria

Ukukhetha iCriteria

Ukufumana i-DGET ukujonga kuphela idatha yedatha yokuthengisa ethile sifaka igama le-arhente phantsi kwegama le- SalesRep kwisebe 3.

1. Kwifowuni yeF3 yenza uhlobo lweHarry
2. Kwifowuni ye-E5 thayipha i- #Orders: ukubonisa ulwazi esiza kulufumana nge-DGET

Ukubiza igama

Ukusebenzisa uluhlu olukhankanyiweyo olubanzi lweedatha ezifana nedatha ayikwazi ukwenza kube lula ukufaka le ngxabano kumsebenzi, kodwa kunokuthintela iimpazamo ezibangelwa ngokukhetha uluhlu olungalunganga.

Amanqanaba aqingqiweyo ayanceda kakhulu xa usebenzisa uluhlu olufanayo lweeseli rhoqo kwizibalo okanye xa udala amashadi okanye iirafu.

1. Gqamisa iiseli D7 ukuya kwi-F13 kwiphepha lokusebenzela ukuze ukhethe uluhlu
2. Cofa kwibhokisi yegama ngaphaya kwekholomu A kwiphepha lokusebenzela
3. Thayipha i- SalesData kwibhokisi legama ukudala uluhlu olukhankanyiweyo
4. Cinezela ukhiye wokungena kwikhibhodi ukugqiba ukungena

Ukuvula ibhokisi yeDGET yeDoalog

Ibhokisi yencoko yencoko yomsebenzi inikeza indlela elula yokufaka idatha kwiingxoxo zomsebenzi ngamnye.

Ukuvula ibhokisi yencoko yeqela leenkcukacha lemisebenzi lenziwa ngokuchofoza kwiqhosha lomsebenzi wizard ( fx ) elisezantsi kwibha yefomula ngaphezulu kwephepha lokusebenzela.

1. Cofa kwi cell E5 - indawo apho iziphumo zomsebenzi ziya kuboniswa
2. Cofa kwiqhosha lomsebenzi wizard ( fx ) ukukhupha ibhokisi yencoko yencoko yokuSebenza
3. Thayipha i- DGET kwi- Khangela yefestile yomsebenzi phezulu kwibhokisi yencoko
4. Cofa kwi- GO iqhosha ukukhangela umsebenzi
5. Ibhokisi yencoko yababini kufuneka ifumane i-DGET kwaye uyilobe kwi-window Yokhetho
6. Cofa Kulungile ukuvula ibhokisi yencoko yencoko ye-DGET

Ukugqiba iiArguments

1. Cofa kwiNgcaciso yedatha yebhokisi yencoko
2. Thayipha igama le- SalesData yegama loluhlu kumgca
3. Cofa kwiNgcambu yomgca kwibhokisi yencoko
4. Thayipha igama le-field #Orders kumgca
5. Cofa kwiNqakrazo yomgca webhokisi yencoko
6. Phakamisa iiseli zeD2 kwiF3 kwishidi lokusebenzela ukufaka uluhlu
7. Cofa Kulungile ukuvala ibhokisi yencoko yencoko yeDGET uze uqedele umsebenzi
8. Impendulo 217 ifanele ibonakale kwiseli ye-E5 njengoko eli liqela leemali zokuthengisa ezibekwa nguHarry kule nyanga
9. Xa ucofa kwi-cell E5 umsebenzi opheleleyo
   = DGET (SalesData, "#Orders", D2: F3) ibonakala kwifom yefom ngaphezu kwiphepha lokusebenzela

Iimpazamo zeSebenzi zeDatabase

#Value : Ivela kuninzi xa amagama omhlaba engabandakanywa kwingxabano yedatha.

Ngokomzekelo ongentla, qiniseka ukuba amagama ensimi kwii-D6: F6 zifakwe kwi- SalesData yegama elikhankanyiweyo .