Maitiro Okushandisa DGET Function mu Excel

01 ye 01

Tsvaga Zvinyorwa Zvakananga mune imwe Excel Database

DGET basa rimwe remabasa eDeccel's database . Iri boka remabasa rakagadzirirwa kuita kuti zvive nyore kupfupisa mashoko kubva pamatafura makuru e data. Vanoita izvi kuburikidza nekudzorera ruzivo rwakajeka kubva pane imwe kana kupfuura zvingasarudzwa nemushandisi.

DGET basa rinogona kushandiswa kudzorera imwe munda we data kubva kune imwe column ye database yakabatana nemamiriro aunofunga.

DGET yakafanana nebasa reVLOOKUP iro rinogona kushandiswa kudzoka kusina imwe minda yedata.

DGET Syntax uye Arguments

Mutsara weDGET basa nderokuti:

= DGET (database, field, criteria)

Zvose zvinoshandiswa pakutsvakurudza mabhuku zvakagadzikana zvakafanana zvitatu:

• Dhiyabhorosi : (inodikanwa) Inotsanangura huwandu hwemaferensi esero rine database. Mazita emunda anofanira kunge akabatanidzwa mukati.
• Munda : (inodikanwa) Inoratidza kuti ndeypi imwe nhare kana munda inofanira kushandiswa nebasa iri kuverenga. Pinda nharo kana kuisa zita remunda (rakadai se #Orders) kana kuisa nhamba yekholomu (yakadai se3 ).
• Mhosva : (inodiwa) Inotarisa rutivi rwemasero ane zvimiso zvakataurwa nemushandisi. Urwu hunofanira kunge runosanganisira imwe zita remunda kubva kune dhesi uye imwechete imwe sero rinotarisa chirwere chinofanira kuongororwa nebasa racho.

Muenzaniso Uchishandisa Dcel DGET Basa: Kufananidza Criterion Chena

Muenzaniso uyu uchashandisa DGET kuwana nhamba yekutengesa mirairo yakaiswa nemumwe mutengesi wekutengesa kwemwedzi wakapiwa.

Kupinda Tutorial Data

Cherechedza: Dzidzo haina kuisa maitiro ekufambisa.

1. Pinda tafura yedhadha mumasero D1 kusvika kuF13
2. Siya sero E5 isina chinhu; iyi ndiyo inoshandiswa DGET fomu
3. Munda unoshandiswa mumasero D2 kusvika kuF2 uchashandiswa sechikamu chebasa reCriteria argument

Kusarudza Mazano

Kuti tipe DGET kutarisa chete data yekutengeserana kunoshandiswa kwatinoita tinoshandisa zita remujeri pasi pezita reMabasa eRep mumutsara wechitatu.

1. Muchitokisi F3 chinyorwa chevhangeri Harry
2. Muchikamu cheE5 chinyorwa chikamu che #Orders: kuratidza ruzivo ruchazowana neDGET

Kunyorera Database

Kushandisa mazita akanzi mazita makuru e data akadai se database haagoni kungoita kuti zvive nyore kupinda mharo iyi mubasa, asi inogonawo kudzivirira kukanganisa kunokonzerwa nokusarudza nzvimbo isina kururama.

Zita rakatumidzwa inobatsira kana iwe ukashandisa masero emamwe masero kakawanda mukuverenga kana pakuumba marati kana mairafu.

1. Simbisai masero D7 kusvika kune F13 mubasa rekushanda kuti musarudze maruva
2. Dzvanya pabhokisi bhokisi pamusoro apa korome A mune pepa rekushanda
3. Tora SalesData muzita rebhokisi kuti ugadzire zita rakarongwa
4. Dhinda pikicha inopinda mubhobhoyo kuti upedze kupinda

Kuvhura DGET Dialog Box

Basa rebhokisi rebhokisi rinopa nzira iri nyore yekupinda dhidhiro yega yega yebasa remashoko.

Kuzarura bhokisi rebhokisi reboka re database rekuita kunoitwa nekutsvaga purogiramu yebasa wizard ( fx ) iri pedyo nebharuti yepamusoro pane pepa pepaji.

1. Dzvanya pane cell E5 - nzvimbo iyo migumisiro yebasa icharatidzwa
2. Dzvanya pane bhidhiyo yebasa wizard ( fx ) kuti uburise Bhokisi reIndaneti reKubatsira
3. Tora DGET mu Tsvaga yewindo rebasa pamusoro pebhokisi rebhokisi
4. Dzvanya ku GO kuenda kunotsvaka basa
5. Bhokisi rebhokisi rinofanira kuwana DGET uye ronyora iri muSarudzo yebasa
6. Dzvanya OK kuti uzarure DGET basa dialog box

Kuzadzisa Arguments

1. Dzvanya paDhesi yeNhamba yebhokisi rebhokisi
2. Tora zita rezita reBusinessData mumuganhu
3. Dzvanya paMunda webhokisi rebhokisi
4. Nyora munda wezita #Orders mumutsara
5. Dzvanya paCriteria line yebhokisi rebhokisi
6. Dzorerai masero D2 kusvika kuF3 mubasa rekushanda kuti uende pakuronga
7. Dzvanya OK kuti uvhare DGET basa dialog box uye upedze basa
8. Mhinduro 217 inofanira kuonekwa muchitokisi E5 sezvo iyi ndiyo nhamba yekutengesa mirairo yakaiswa naHarry mwedzi uno
9. Paunenge uchibvumira pane cell E5 basa rakakwana
   = DGET (SalesData, "#Orders", D2: F3) inowanikwa mubhairi yepamusoro pane pepa rekushanda

Dhiyabhorosi Basa Rinosvibisa

#Value : Inowanzoitika kakawanda apo mazita emumunda akanga asina kubatanidzwa munyaya ye database.

Nokuda kwemuenzaniso uri pamusoro apa, iva nechokwadi chokuti munda unodana mumasero D6: F6 akabatanidzwa mune Zita rinonzi SalesData .