Indlela yokusebenzisa umsebenzi we-DGET ku-Excel

01 ka 01

Thola Amarekhodi Aqondile E-Excel Database

Umsebenzi we-DGET ungomunye wemisebenzi yedatha ye-Excel. Leli qembu lemisebenzi lenzelwe ukwenza kube lula ukufingqa ulwazi kusuka kumatafula amakhulu yedatha. Benza lokhu ngokubuyisela ulwazi oluthile olusekelwe kumgomo owodwa noma ngaphezulu okhethwe umsebenzisi.

Umsebenzi we-DGET ungasetshenziswa ukubuyisela insimu eyodwa yedatha kusuka kukholomu yedatha ehambisana nezimo ozibekayo.

I-DGET ifana nomsebenzi we-VLOOKUP ongasetshenziselwa ukubuyisela amasimu owodwa wedatha.

I-Syntax ye-DGET nama-Arguments

I- syntax yomsebenzi we-DGET yile:

= DGET (i-database, field, criteria)

Yonke imisebenzi yedatha inezimpikiswano ezintathu ezifanayo:

• Idatha : (edingekayo) Icacisa ububanzi bezinkomba ezigciniwe eziqukethe idatha. Amagama ensimu kumele afakwe ebangeni.
• Insimu : (edingekayo) Ibonisa ukuthi iyiphi ikholomu noma insimu okufanele isetshenziswe umsebenzi ekubalweni kwayo. Faka ingxabano noma ngokuthayipha igama lesimu (njenge-# Orders) noma faka inombolo yekholomu (njenge-3).
• Imigomo : (edingekayo) Uhlela ububanzi bamaseli aqukethe izimo ezichazwe umsebenzisi. Ububanzi kumele bubandakanye okungenani igama elilodwa lesimu kusuka ku-database futhi okungenani enye ireferensi yeseli ekhombisa isimo okufanele sihlolwe ngumsebenzi.

Isibonelo Ukusebenzisa i-DGET Umsebenzi we-Excel: Ukufanisa I-Criteria eyodwa

Lesi sibonelo sizosebenzisa i- DGET ukuthola inombolo ye-oda yokuthengisa elibekwe yileli vele yokuthengisa enyangeni enikeziwe.

Ukufaka idatha yokufundisa

Qaphela: Ukufundisa akubandakanyi izinyathelo zokufometha.

1. Faka ithebula yedatha kumaseli D1 kuya ku-F13
2. Shiya iseli E5 lingenalutho; yilapho ifomula ye-DGET izotholakala khona
3. Amagama endle kumaseli D2 kuya ku-F2 azosetshenziselwa njengengxenye yengxabano yomsebenzi weCriteria

Ukukhetha i-Criteria

Ukuze uthole i-DGET ukuthi ibheke kuphela idatha ye-rep rep yokuthengisa ethile sifaka igama le-ejenti ngaphansi kwegama leSitolo leRayRep emgqeni wesi-3.

1. Esitokisini F3 thayipha indlela uHarry
2. Esikhathini se-E5 thayipha okulandelayo # okulandelayo: ukukhombisa imininingwane esizoyithola nge-DGET

Ukubiza i-Database

Ukusebenzisa uhla olubizwa ngokuthi yizinhlu ezinkulu zemininingwane efana nedatha angeke yenza kube lula ukufaka le mpikiswano emsebenzini, kodwa kungavimbela amaphutha abangelwa ukukhetha ibanga elingalungile.

Amanothi aqanjwe abalulekile kakhulu uma usebenzisa uhla olufanayo lwamaseli njalo ngezibalo noma uma udala amashadi noma amagrafu.

1. Gqamisa amaseli D7 kuya ku-F13 kushidi lokusebenzela ukuze ukhethe uhla
2. Chofoza ebhokisini legama ngenhla ikholomu A kuphepha lokusebenzela
3. Thayipha i- SalesData ebhokisini igama ukuze udale ububanzi obuqanjwe
4. Cindezela ukhiye wokungena kwikhibhodi ukuqedela ukungena

Ukuvula ibhokisi le-DGET lokuxoxa

Ibhokisi lengxoxo lomsebenzi linikeza indlela elula yokufaka idatha ngayinye yeziphakamiso zomsebenzi.

Ukuvula ibhokisi lebhokisi leqembu lemininingwane yedatha lenziwa ngokuchofoza inkinobho yomsebenzi wizard ( fx ) esekelwe eceleni kwebhafomula ngaphezulu kwephepha lokusebenzela.

1. Chofoza kuseli E5 - indawo lapho imiphumela yomsebenzi izoboniswa khona
2. Chofoza inkinobho yomsebenzi wizard ( fx ) ukuletha ibhokisi lengxoxo yokufaka umsebenzi
3. Thayipha i- DGET ku- Usesho lwewindi lomsebenzi phezulu kwebhokisi lengxoxo
4. Chofoza inkinobho ye- GO ukucinga lo msebenzi
5. Ibhokisi lebhokisi kumele lithole i-DGET bese ulibhala ohlwini lweWindows
6. Chofoza u-KULUNGILE ukuvula ibhokisi lengxoxo ye-DGET ibhokisi

Ukugcwalisa iziphakamiso

1. Chofoza ku- Database database yebhokisi lengxoxo
2. Thayipha igama le- SalesData yebanga lokuya ohlwini
3. Chofoza ku- Field field yebhokisi lengxoxo
4. Thayipha igama lezinsimu #Izikhathi eziya emgqeni
5. Chofoza kulayini Wokuqondisa ebhokisini lengxoxo
6. Qinisekisa amaseli D2 kuya ku-F3 ekhasini lokusebenzela ukuze ungene ebangeni
7. Chofoza u-Kulungile ukuvala ibhokisi lebhokisi le-DGET bese uqedela umsebenzi
8. Impendulo 217 kufanele ivele esitokisini se-E5 njengoba lena yinombolo ye-oda yokuthengisa elibekwe nguHarry kule nyanga
9. Uma uchofoza ku-cell E5 umsebenzi ophelele
   = DGET (SalesData, "#Orders", D2: F3) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela

Amaphutha Okusebenza Nge-Database

I-#Value : Ivela kakhulu kaningi uma amagama ensimu engakafakiwe ku-argument yedatha.

Ngesibonelo esingenhla, qiniseka ukuthi amagama ensimu kumaseli D6: F6 afakwe ku- SalesData ebizwa ngokuthi u-range.