Kusetshenziswa umsebenzi othi VIEW ku-Excel

Uhlelo lwe-Excel lukuvumela ukuthi ungagcini nje ngokufaka idatha etafuleni, kodwa futhi ukuyicubungula ngezindlela ezahlukahlukene. Njengengxenye yale ncwadi, sizocabangela ukuthi kungani lo msebenzi udingeka VIEW nokuthi ungayisebenzisa kanjani.

Izinzuzo ezingokoqobo

VIEW isetshenziselwa ukuthola nokubonisa inani elivela kuthebula eliseshwayo ngokucubungula/ukufanisa ipharamitha eshiwo umsebenzisi. Isibonelo, sifaka igama lomkhiqizo kuseli ehlukile, futhi inani lawo, ubuningi, njll. zivela ngokuzenzakalelayo kuseli elandelayo. (kuye ngokuthi yini esiyidingayo).

Umsebenzi VIEW icishe ifane ne-, kodwa ayinandaba noma amanani ebukekayo phezulu akukholomu ekwesokunxele impela.

Ukusebenzisa umsebenzi VIEW

Ake sithi sinetafula elinamagama ezimpahla, inani lazo, inani kanye nenani.

Qaphela: idatha ezoseshwa kufanele ihlelwe ngokuqinile ngendlela ekhuphukayo, ngaphandle kwalokho umsebenzi VIEW ngeke isebenze kahle, okungukuthi:

• Izinombolo: … -2, -1, 0, 1, 2…
• Izincwadi: kusuka ku-A kuya ku-Z, kusuka ku-A kuya ku-Z, njll.
• Izinkulumo eziphusile: AMANGA, IQINISO.

Ungasebenzisa .

Kunezindlela ezimbili zokusebenzisa umsebenzi VIEW: Ifomu le-vector kanye nefomu lohlu. Ake sihlolisise ngayinye yazo.

Indlela 1: umumo we-vector

Abasebenzisi be-Excel bavame ukusebenzisa le ndlela. Nakhu okuyikho:

1. Eduze kwetafula lokuqala, dala elinye, unhlokweni oqukethe amakholomu anamagama “Inani elifunekayo” и "Umphumela". Eqinisweni, lokhu akuyona imfuneko, noma kunjalo, kulula ukusebenza nomsebenzi ngale ndlela. Amagama ezihloko nawo angahluka.
2. Sima esitokisini lapho esihlela khona ukubonisa umphumela, bese uchofoza isithonjana "Faka umsebenzi" kwesokunxele sebha yefomula.
3. Iwindi lizovela phambi kwethu Umsebenzi Wizards. Lapha sikhetha isigaba “Uhlu oluphelele lwama-alfabhethi”, skrolela phansi ohlwini, thola u-opharetha “BUKA”, yimaka bese uchofoza OK.
4. Iwindi elincane lizovela esikrinini lapho sidinga ukukhetha khona uhlu olulodwa lwezimpikiswano ezimbili. Kulokhu, simisa ekukhetheni kokuqala, ngoba. ukuhlahlela umumo we-vector.
5. Manje sidinga ukugcwalisa izimpikiswano zomsebenzi, bese uchofoza inkinobho OK:
   • “Bheka_inani” - lapha sibonisa izixhumanisi zeseli (sibhala ngesandla noma sivele sichofoze into oyifunayo etafuleni ngokwalo), lapho sizofaka khona ipharamitha okuzoseshwa ngayo. Esimweni sethu, lokhu kunjalo "F2".
   • I-"Viewed_Vector" - cacisa ububanzi bamaseli okuzoseshwa phakathi kwawo inani olifunayo (sinalokhu “A2:A8”). Lapha singaphinda sifake izixhumanisi mathupha, noma sikhethe indawo edingekayo yamaseli kuthebula ngenkinobho yegundane engakwesokunxele ibanjwe phansi.
   • “Vector_result” - lapha sibonisa ububanzi ongakhetha kuzo umphumela ohambisana nenani elifunekayo (lizoba semugqeni ofanayo). Esimeni sethu, ake "Ubuningi, ama-PC.", okungukuthi ububanzi "C2:C8".
6. Esitokisini esinefomula, sibona umphumela “#N/A”, okungase kubonakale njengephutha, kodwa akulona iqiniso ngokuphelele.
7. Ukuze umsebenzi usebenze, sidinga ukungena kuseli "F2" igama elithile (isibonelo, “Sinki”) equkethwe kuthebula lomthombo, icala alibalulekile. Ngemva kokuchofoza Faka, umsebenzi uzokhipha umphumela oyifunayo (sizoba nawo 19 pc).Qaphela: abasebenzisi abanolwazi bangenza ngaphandle Umsebenzi Wizards bese ufaka ngokushesha ifomula yomsebenzi kulayini ofanele nezixhumanisi zamaseli adingekayo nobubanzi.

Indlela yesi-2: Ifomu le-Array

Kulokhu, sizosebenza ngokushesha nawo wonke amalungu afanayo, afaka ngesikhathi esisodwa kokubili ububanzi (okubukiwe nemiphumela). Kodwa kunomkhawulo obalulekile lapha: ububanzi obubukiwe kufanele bube yikholomu engaphandle kakhulu yohlelo olunikeziwe, futhi ukukhethwa kwamanani kuzokwenziwa kusukela kukholomu engakwesokudla. Ngakho-ke, ake siqale ukusebenza:

1. Faka umsebenzi kuseli ukuze ubonise umphumela VIEW – njengasendleleni yokuqala, kodwa manje sikhetha uhlu lwama-agumenti lwamalungu afanayo.
2. Cacisa ama-agumenti omsebenzi bese uchofoza inkinobho OK:
   • “Bheka_inani” - igcwaliswe ngendlela efanayo neyefomu le-vector.
   • "Array" – setha izixhumanisi zalo lonke uhlelo (noma likhethe kuthebula ngokwalo), kufaka phakathi ububanzi obubukwayo kanye nendawo yemiphumela.
3. Ukusebenzisa umsebenzi, njengasendleleni yokuqala, faka igama lomkhiqizo bese uchofoza Faka, ngemva kwalokho umphumela uzovela ngokuzenzakalelayo kuseli nefomula.

Qaphela: uhlu lwefomu lomsebenzi VIEW okungavamile ukusetshenziswa, tk. isiphelelwe yisikhathi futhi ihlala kuzinguqulo zesimanje ze-Excel ukuze kugcinwe ukuhambisana nezincwadi zokusebenza ezidalwe ezinguqulweni zangaphambili zohlelo. Kunalokho, kuyafiseleka ukusebenzisa imisebenzi yesimanje: VPR и I-GPR.

Isiphetho

Ngakho, ku-Excel kunezindlela ezimbili zokusebenzisa umsebenzi we-LOOKUP, kuye ngohlu olukhethiwe lwama-agumenti (ifomu le-vector noma ifomu lebanga). Ngokufunda indlela yokusebenzisa leli thuluzi, kwezinye izimo, unganciphisa kakhulu isikhathi sokucubungula ulwazi, unake imisebenzi ebaluleke kakhulu.