Ingero zimikorere ya RFD muri Excel

Gukorana nu mbonerahamwe rusange bikubiyemo gukurura indangagaciro kubandi mazi muri yo. Niba hari ameza menshi, umuvuduko wintoki uzatwara igihe kinini, kandi niba amakuru asanzwe agezweho, bizaba umunyeshuri wakazi. Kubwamahirwe, hari imikorere ya Hpp, itanga ubushobozi bwo guhita gutoranya amakuru. Reka dusuzume ingero zihariye ziki gikorwa.

Ibisobanuro by'imikorere ya FPR

Izina ryimikorere ya FPR rifunguye nkibikorwa bya "uhagaritse ibintu". Mu Cyongereza, izina ryaryo amajwi - Vlookup. Iyi mikorere irashaka amakuru murwego rwibumoso rwurwego, hanyuma agasubiza agaciro kavuye kuri selile. Muri make, ubuhanzi bugufasha guhindura indangagaciro kuva muri selile yimeza imwe kumeza. Shakisha uburyo bwo gukoresha imikorere ya Vlookup muri Excel.

Urugero rwo gukoresha UPR

Turareba uburyo imikorere ya PRD ikora kurugero runaka.

Dufite ameza abiri. Iya mbere muribo ni ameza yo gutanga amasoko, ikubiyemo amazina y'ibiryo. Inkingi ikurikira nyuma yizina ni agaciro k'umubare wibicuruzwa ushaka kugura. Ibikurikira ikurikira igiciro. Kandi mu nkingi iheruka - Igiciro cyose cyo kugura izina ryihariye ryibicuruzwa, bibarwa kuri selire ya formulaire igwira ku giciro. Ariko igiciro tugomba gusaka gusa ukoresheje imikorere yingabo kuva kumeza ikurikira, nikindi urutonde rwibiciro.

1. Kanda kuri selile yo hejuru (C3) muri "Igiciro" mumeza yambere. Noneho, kanda ahanditse "Shyiramo imikorere", iherereye imbere yumurongo wa formula.



2. Mu idirishya rikora rya Shebuja imikorere, hitamo icyiciro "amahuza na arrays". Noneho, uhereye kuri gahunda zatanzweho, hitamo "VDP". Kanda kuri buto ya "OK".



3. Nyuma yibyo, idirishya rifungura aho ukeneye gushyiramo imikorere. Twahagaritse kuri buto iherereye iburyo bwamakuru yo kwinjiza amakuru kugirango dukomeze guhitamo impaka zagaciro wifuza.



4. Kubera ko dufite agaciro ka CYIZA KIGARAGAZA CUPRRT C3, ni "Ibirayi", noneho tugenera agaciro gahuye. Garuka kumurimo uganira idirishya.



5. Mu buryo nk'ubwo, mbasinda ku gishushanyo iburyo bw'umurima wo kwinjira, guhitamo ameza, aho indangagaciro zizakomeza.



6. Turagaragaza aho byose byameza ya kabiri, aho gushakisha indangagaciro usibye ingofero izakorwa. Na none, dusubira mubikorwa byimikorere.



7. Kugirango indangagaciro zatoranijwe zo gukora zivuye kuri ugereranije, kandi ibi dukeneye ko indangagaciro zidagenda hamwe nimpinduka yakurikiyeho, hitamo umurima mukibuga cya "Imbonerahamwe", hanyuma ukande kuri F4 urufunguzo. Nyuma yibyo, amahuza yidolari yongewe kumurongo kandi ihinduka rwose.



8. Mu mubare wakurikiyeho, dukeneye kwerekana umubare winkingi aho tuzerekana indangagaciro. Iyi nkingi iherereye mumeza yerekanwe hejuru. Kubera ko imbonerahamwe igizwe ninkingi ebyiri, kandi inkingi hamwe nibiciro nicya kabiri, noneho twashizeho umubare "2".
9. Mu nkingi iheruka kureba "intera", dukeneye kwerekana agaciro "0" (ibinyoma) cyangwa "1" (ukuri). Ku rubanza rwa mbere, gusa aho duhurira ni impanuka gusa, kandi mubya kabiri - hafi cyane. Kubera ko izina ryibicuruzwa ari inyandiko, ntishobora kuba hafi, bitandukanye namakuru, dukeneye rero gushyira agaciro "0". Ibikurikira, kanda buto "OK".

Nkuko mubibona, igiciro cyibirayi cyakuwe mumeza kuva kurutonde rwibiciro. Kugirango utazakora uburyo bugoye nkandi mazina yibicuruzwa, bihinduka mugice cyo hepfo iburyo bwa selile yuzuye, kugirango umusaraba ugaragara. Turasohoza uyu musaraba kugeza munsi yimbonerahamwe.

Rero, twakuye amakuru yose akenewe kuva kumeza imwe tujya mubindi, ukoresheje imikorere ya VDP.

Nkuko tubibona, imikorere yubukemurampaka ntabwo igoye, nkuko bigaragara mbere. Ntabwo bigoye cyane kubyumva porogaramu zacyo, ariko iterambere ryiki gikoresho rizagukiza igihe cyigihe iyo nkorana nameza.