Imizekelo yomsebenzi we-RFD kwi-Excel

Ukusebenza netheyibhile yokuxhasa ngokubanzi kubandakanya ukudonsa amaxabiso avela kwezinye iitafile kuyo. Ukuba kukho iitafile ezininzi, ukuhanjiswa ngesandla kuya kuthatha ixesha elininzi, kwaye ukuba idatha ihlaziywa rhoqo, iya kuba yi-syyfeards. Ngethamsanqa, kukho umsebenzi we-HPP, enikezela amandla okwenza idatha ngokuzenzekelayo. Makhe siqwalasele imizekelo ethile yalo msebenzi.

Inkcazo ye-FPR

Igama lomsebenzi we-FPR uqinisekile njengo "msebenzi wokujonga nkqo". NgesiNgesi, igama layo lezandi - Vlookup. Eli nqaku likhangela idatha kuluhlu lwasekhohlo loluhlu loluhlu, kwaye emva koko ibuyise ixabiso lesiphumo kwiseli echaziweyo. Ngamafutshane, ubugcisa buvumela ukuba uphinde uphinde uphinde usebenzise amaxabiso etafile enye kwenye itafile. Fumana indlela yokusebenzisa umsebenzi weVlookup kwi-Excel.

Umzekelo wokusebenzisa i-upr

Sijonga indlela umsebenzi wePRD usebenza ngayo kumzekelo othile.

Sineetafile ezimbini. Owokuqala kubo yitafile yokuthengwa, enamagama okutya. Ikholam elandelayo emva kwegama lixabiso lenani lezinto ofuna ukuzithenga. Okulandelayo kulandela ixabiso. Kwaye kwikholamu yokugqibela - indleko iyonke yokuthenga igama elithile lemveliso, ebalwa kwiseli yefomyula yokuphindaphinda ngexabiso. Kodwa ixabiso esinalo lokuqinana nokusebenzisa umsebenzi wemikhosi exhobileyo evela kwitafile elandelayo, oluluhlu lwamaxabiso.

1. Cofa kwiseli ephezulu (c3) kwikholam "yexabiso" kwitafile yokuqala. Emva koko, cofa kwi "fasa umsebenzi" i-icon, efumaneka phambi kwefom yefomula.



2. Kwifestile yokusebenza ye-Master yemisebenzi, khetha udidi "Amakhonkco kunye neCorys". Emva koko, ukusuka kwiseti yemisebenzi, khetha "VDP". Cofa kwiqhosha "Kulungile".



3. Emva koko, iwindow ivula apho kufuneka ufake khona impikiswano yomsebenzi. Sicofa kwiqhosha elisekunene kwentsimi yokungena yedatha ukuqhubeka nokukhethwa kwengxoxo yexabiso elifunayo.



4. Kuba sinexabiso elinqwenelekayo kwiseli C3, yi "iitapile", emva koko sibelane ngexabiso elihambelanayo. Buyela kwi-World Report windows.



5. Ngokufanayo, ndicofa kwi icon ngasekunene kwentsimi yokungena yedatha, ukukhetha itafile, ukusuka apho amaxabiso aya kuqina khona.



6. Sibalaselisa yonke indawo yetafile yesibini, apho ukufuna iimpawu ngaphandle kwekhephu kuya kwenziwa. Kwakhona, sibuyela emsebenzini weengxoxo zomsebenzi.



7. Ukuze ixabiseke kwixabiso elikhethiweyo ukubonisa ngokupheleleyo, kwaye oku kufuneka ukuba iinqobo zokuziphatha azihambi kakuhle kwetafile elandelayo, zikhetha ikhonkco kwintsimi "yetafile", kwaye ucofe kwi-F4 Isitshixo somsebenzi. Emva koko, amakhonkco edola yongezwa kwikhonkco kwaye ijika ifikelele phambili.



8. Kwinombolo elandelayo yekholamu, kufuneka sichaze inani lekholamu ukusuka apho siza kubonisa khona amaxabiso. Le kholamu ibekwe kwitafile eqaqanjiswe ngasentla. Kuba itafile iqulathe iikholamu ezimbini, kwaye ikholamu yamaxabiso ngowesibini, emva koko sibeke inani "2".
9. Kumqolo wokugqibela "I-Interval Jonga", kufuneka sikhankanya ixabiso "0" (ubuxoki) okanye "1" (inyani). Kwimeko yokuqala, kuchanekile ngokuchanekileyo, kwaye okwesibini - osondeleyo. Kuba igama lemveliso yidatha yetekisi, ayinakuphakanyiswa, ngokungafaniyo nedatha yamanani, ke kufuneka sibeke ixabiso "0". Okulandelayo, cinezela iqhosha u "Kulungile".

Njengoko ubona, ixabiso leetapile likhutshelwe kwitafile ukusuka kuluhlu lwamaxabiso. Ukulungiselela ukuba bangazenzi inkqubo entsonkothileyo kunye namanye amagama emveliso, yiba kwikona esezantsi ngasekunene kweseli ezaliswe, ukuze umnqamlezo uyavela. Siyenza lo mnqamlezo uye ezantsi kwetafile.

Ke, sayitsalela yonke idatha eyimfuneko ukusuka kwenye itafile ukuya kwenye, usebenzisa umsebenzi we-VDP.

Njengoko sibona, umsebenzi wolwaluko awunzima, njengoko kubonakala ngathi uqaphele kuqala. Akunzima kakhulu ukuqondakala isicelo sayo, kodwa ukuphuculwa kwesi sixhobo kuya kukusindisa ubunzima bexesha xa usebenza neetafile.