Uchishandisa iyo VIEW basa muExcel

Iyo Excel chirongwa chinokutendera iwe kwete chete kuisa data mutafura, asi zvakare kuigadzirisa nenzira dzakasiyana. Sechikamu chebhuku rino, tichaona kuti nei basa racho richidiwa ONA uye kuti ungashandisa sei.

Zvibereko zvinoshanda

ONA inoshandiswa kutsvaga uye kuratidza kukosha kubva patafura iri kutsvakwa nekugadzirisa/kufananidza parameter inotsanangurwa nemushandisi. Semuenzaniso, isu tinoisa zita rechigadzirwa musero rakasiyana, uye mutengo wayo, huwandu, nezvimwe zvinongoerekana zvabuda musero rinotevera. (zvichienderana nezvatinoda).

basa ONA zvakada kufanana ne , asi hazvina basa kana hunhu hwainotarisa kumusoro huri mumutsara wekuruboshwe chete.

Kushandisa iyo VIEW basa

Ngatitii tine tafura ine mazita ezvigadzirwa, mutengo wazvo, huwandu uye huwandu.

Cherechedza: iyo data inofanirwa kutsvakwa inofanirwa kurongeka zvakanyatsorongeka mukukwira, kana zvisina kudaro basa ONA haishande nemazvo, kureva:

• Numeri: … -2, -1, 0, 1, 2…
• Tsamba: kubva A kusvika Z, kubva A kusvika Z, zvichingodaro.
• Boolean expressions: NHEMA, CHOKWADI.

Unogona kushandisa.

Pane nzira mbiri dzekushandisa basa racho ONA: vector fomu uye array fomu. Ngatinyatsoongororai imwe neimwe yadzo.

Nzira 1: vector chimiro

Vashandisi veExcel vanowanzo shandisa nzira iyi. Hezvino zvazviri:

1. Pedyo netafura yepakutanga, gadzira imwe, iyo musoro ine makoramu ane mazita "Kukosha kunodiwa" и "Chigumisiro". Muchokwadi, ichi hachisi chinhu chinodiwa, zvisinei, zviri nyore kushanda nebasa nenzira iyi. Mazita emusoro anogonawo kunge akasiyana.
2. Isu tinomira muchitokisi matinoronga kuratidza mhedzisiro, uye tinya pane icon "Isa basa" kuruboshwe rweformula bar.
3. Hwindo richaonekwa pamberi pedu Basa Wizards. Pano tinosarudza chikamu “Runyorwa ruzere rwearufabheti”, penya pasi pasi, tsvaga mushandisi “ONA”, imaka uye tinya OK.
4. Iwindo diki richaonekwa pachiratidziro chatinoda kusarudza imwe yemazita maviri emakakatanwa. Muchiitiko ichi, tinomira pane yekutanga sarudzo, nokuti. kushandura chimiro chevector.
5. Iye zvino tinoda kuzadza nharo dzebasa racho, uye tinya bhatani OK:
   • "Kutsvaga_kukosha" - pano tinoratidza kurongeka kwesero (isu tinoinyora nemaoko kana kungodzvanya pane chinhu chaunoda mutafura pachayo), iyo yatinozopinda nayo parameter iyo yekutsvaga ichaitwa. Muchiitiko chedu, izvi ndizvo "F2".
   • "Viewed_Vector" - tsanangura huwandu hwemasero pakati pekutsvaga kukosha kwaunoda kuchaitwa (tine izvi "A2:A8") Pano isu tinokwanisa zvakare kuisa makongiresi nemaoko, kana kusarudza nzvimbo inodiwa yemasero mutafura neruboshwe bhatani rakabatwa pasi.
   • "result_vector" - pano tinoratidza huwandu kubva pakusarudza mugumisiro unoenderana nehuwandu hunodiwa (huchava mumutsara wakafanana). Kwatiri, ngatiitei "Huwandu, pcs.", kureva range "C2:C8".
6. Musero neformula, tinoona mhedzisiro "#N/A", iyo inogona kuonekwa sechikanganiso, asi hachisi chokwadi zvachose.
7. Kuti basa rishande, tinofanira kupinda muchitokisi "F2" rimwe zita (semuenzaniso, “Sink”) iri mudura tafura, nyaya haina kukosha. Mushure mekunge tadzvanya pinda, basa racho rinongodhonza mhedzisiro yaunoda (tichave nayo 19 pc).Cherechedza: vashandisi vane ruzivo vanogona kuita pasina Basa Wizards uye pakarepo pinda fomu yekushanda mumutsara wakakodzera nekubatanidza kune masero anodiwa uye mitsara.

Nzira 2: Array Form

Muchiitiko ichi, isu tichashanda nekukurumidza nehurongwa hwese, uhwo panguva imwe chete hunosanganisira ese ari maviri mativi (anoonekwa nemhedzisiro). Asi pane kuganhurirwa kwakakosha pano: iyo yakatariswa chiyero inofanira kunge iri yekunze koramu yeiyo yakapihwa array, uye kusarudzwa kwehunhu kuchaitwa kubva kukona yekurudyi. Saka, ngatitange kushanda:

1. Isa basa musero kuratidza mhedzisiro ONA - semune nzira yekutanga, asi ikozvino tinosarudza runyoro rwemakakatanwa eiyo array.
2. Tsanangura mapeji emabasa uye tinya bhatani OK:
   • "Kutsvaga_kukosha" - yakazadzwa nenzira imwechete neyevector fomu.
   • "Array" - seta maratidziro eiyo array yese (kana sarudza iyo mutafura pachayo), kusanganisira huwandu huri kutariswa uye nzvimbo yemhedzisiro.
3. Kuti ushandise basa, senge nzira yekutanga, isa zita rechigadzirwa uye tinya pinda, mushure mezvo mhedzisiro yacho ichangoerekana yaonekwa muchitokisi neformula.

Cherechedza: array fomu yebasa ONA isingawanzo shandiswa, tk. haichashandi uye inoramba iri mushanduro dzemazuva ano dzeExcel kuchengetedza kuenderana nemabhuku ebasa akagadzirwa mushanduro dzekutanga dzechirongwa. Pane kudaro, zvinodikanwa kushandisa mabasa emazuva ano: VPR и GPR.

mhedziso

Saka, muExcel pane nzira mbiri dzekushandisa basa reLOOKUP, zvichienderana nerondedzero yakasarudzwa yenharo (vector fomu kana renji fomu). Nokudzidza kushandisa chishandiso ichi, mune dzimwe nguva, unogona kuderedza zvakanyanya nguva yekugadzira ruzivo, uchiteerera kune akakosha mabasa.