txheem
Txhawm rau nrhiav cov txiaj ntsig ntawm lub xov tooj ntawm tes nyob ntawm kev sib tshuam ntawm kab thiab kab hauv kab lus hauv Microsoft Office Excel, koj yuav tsum siv "INDEX" muaj nuj nqi, nrog rau pab pawg "Tshawb nrhiav". Nrhiav tus nqi hauv cov array yog xav tau thaum tus neeg siv ua haujlwm nrog lub rooj loj, thiab nws yuav tsum "rub" cov ntaub ntawv ntau. Kab lus no yuav saib cov ncauj lus kom ntxaws txog kev siv "INDEX" ua haujlwm los tshawb nrhiav cov txiaj ntsig hauv ib qho array.
Sau cov haujlwm "INDEX".
Xws li tus neeg teb xov tooj array yog sau raws li hauv qab no: =INDEX(array; kab zauv; kab zauv). Hloov cov lus nyob rau hauv brackets, cov xov tooj sib raug ntawm cov hlwb hauv cov lus qub yog qhia.
Sau qhov "MATCH" muaj nuj nqi
Qhov no yog tus neeg ua haujlwm pabcuam rau thawj qhov haujlwm, uas tseem yuav siv tau thaum saib cov nqi hauv cov array. Nws cov ntaub ntawv hauv Excel zoo li no: =MATCH(tus nqi los nrhiav; rooj array; hom hom).
Ua tib zoo mloog! Thaum sau cov lus sib cav rau INDEX muaj nuj nqi, kab zauv yog xaiv tau.
Yuav ua li cas nrhiav tau tus nqi hauv ib qho array
Txhawm rau nkag siab lub ntsiab lus, algorithm rau kev ua haujlwm yuav tsum raug txiav txim siab siv ib qho piv txwv tshwj xeeb. Cia peb ua ib lub rooj ntawm kev txiav txim hauv Excel rau ib hnub, uas yuav muaj kab: "tus lej xaj", "Cov neeg siv khoom", "Cov khoom", "Qib", "Unit price", "Amount". Koj yuav tsum nrhiav tus nqi hauv cov array, piv txwv li tsim ib tus neeg siv khoom xaj daim npav kom koj tuaj yeem tau txais cov ntaub ntawv hauv daim ntawv compressed los ntawm cov hlwb ntawm thawj lub rooj.
Txhawm rau ua qhov no, koj yuav tsum ua cov haujlwm ua haujlwm raws li algorithm:
- Tsim ib daim npav rau cov neeg siv khoom.
- Rau thawj kab ntawm daim npav, koj yuav tsum tsim ib daim ntawv teev npe uas cov npe ntawm cov neeg siv khoom yuav raug sau. Tom qab ntawd, los ntawm kev xaiv ib lub npe tshwj xeeb, tus neeg siv yuav pom cov ntaub ntawv tseem ceeb ntawm nws, uas yuav tshwm sim hauv lwm kab ntawm daim npav xaj.
- Muab tus nas cursor tso rau hauv thawj kab ntawm daim npav thiab nkag mus rau ntu "Cov ntaub ntawv" nyob rau sab saum toj ntawm cov ntawv qhia zaub mov tseem ceeb ntawm qhov program.
- Nyem rau ntawm "Data Validation" khawm.
- Nyob rau hauv lub qhov rais uas tshwm, nyob rau hauv lub "Cov ntaub ntawv hom" teb, xaiv "Tsev" kev xaiv, thiab xaiv qhov ntau ntawm cov cell ntawm cov thawj array raws li qhov chaw, nyob rau hauv uas cov npe ntawm tag nrho cov neeg tau txais kev pab.
- Ib tug xub yuav tshwm nyob rau sab xis ntawm lub xov tooj ntawm tes nyob rau hauv thawj kab ntawm daim npav. Yog tias koj nyem rau ntawm nws, koj tuaj yeem pom cov npe ntawm txhua tus neeg siv khoom. Ntawm no koj yuav tsum xaiv cov neeg siv khoom.
- Hauv kab "tus lej xaj" sau cov haujlwm «=INDEX(», Tom qab ntawd nyem rau ntawm "fx" icon nyob ib sab ntawm Excel daim ntawv qhia bar.
- Hauv cov ntawv qhia ua haujlwm Wizard uas qhib, xaiv daim ntawv array rau "INDEX" ua haujlwm los ntawm cov npe thiab nyem rau ntawm "OK".
- Lub qhov rais "Function Arguments" yuav qhib, uas koj yuav tsum tau sau tag nrho cov kab, qhia txog qhov sib thooj ntawm cov hlwb.
- Ua ntej koj yuav tsum tau nyem rau ntawm lub icon rov qab "Array" teb thiab xaiv tag nrho cov thawj phaj nrog rau lub header.
- Nyob rau hauv lub teb "Kab xov tooj" koj yuav tsum tau sau nyob rau hauv lub functionality "MATCH". Hauv thawj qhov chaw hauv kab lus, raws li kev sib cav, peb qhia lub npe ntawm tus neeg siv khoom uas tau xaiv hauv daim npav xaj. Raws li qhov kev sib cav thib ob ntawm "MATCH" muaj nuj nqi, koj yuav tsum tau qhia tag nrho cov neeg siv khoom hauv thawj lub rooj array. Nyob rau hauv qhov chaw ntawm qhov kev sib cav thib peb, koj yuav tsum sau tus naj npawb 0, vim tias yuav nrhiav kev sib tw.
Tseem ceeb! Tom qab sau rau hauv txhua lub ntsiab lus rau "MATCH" muaj nuj nqi, koj yuav tsum nias lub pob "F4" los dai cov cim nyiaj daus las nyob rau pem hauv ntej ntawm txhua tus cim hauv kev sib cav. Qhov no yuav tso cai rau cov qauv tsis txhob "tshem tawm" hauv kev ua tiav.
- Hauv kab "Kem lej" ib zaug ntxiv sau cov haujlwm pabcuam "MATCH" nrog cov lus pom zoo.
- Raws li thawj qhov kev sib cav rau qhov kev ua haujlwm, koj yuav tsum qhia meej lub xov tooj khoob hauv kab "Cov Khoom" hauv daim npav xaj. Nyob rau tib lub sijhawm, nws tsis tas yuav dai cov cim nyiaj daus las ntawm kev sib cav, vim tias qhov kev sib cav xav tau yuav tsum yog "floating".
- Sau nyob rau hauv qhov kev sib cav thib ob ntawm "MATCH" muaj nuj nqi, koj yuav tsum xaiv lub header ntawm qhov chaw array, thiab tom qab ntawd nias lub pob "F4" los kho cov cim.
- Raws li qhov kev sib cav zaum kawg, koj yuav tsum sau 0, kaw lub bracket thiab nyem rau ntawm "OK" nyob rau hauv qab ntawm "Function Arguments" box. Hauv qhov xwm txheej no, tus lej 0 yog qhov sib tw tiag tiag.
- Tshawb xyuas qhov tshwm sim. Tom qab ua qhov kev txiav txim ntev, tus lej sib raug rau cov neeg siv khoom xaiv yuav tsum tau muab tso rau hauv kab "xov tooj xaj".
- Nyob rau theem kawg, cov qauv yuav tsum tau ncab mus rau tag nrho cov hlwb ntawm daim npav xaj mus rau qhov kawg txhawm rau txhawm rau sau cov kab ntxiv.
Cov ntaub ntawv ntxiv! Thaum tus neeg siv khoom raug xaiv los ntawm daim ntawv teev npe poob ntawm daim npav xaj, tag nrho cov ntaub ntawv ntawm tus neeg no yuav raug muab tso rau hauv cov kab seem ntawm cov array.
xaus
Yog li, txhawm rau nrhiav tus nqi xav tau hauv array hauv Microsoft Office Excel, tus neeg siv yuav tau ua haujlwm ntau. Yog li ntawd, yuav tsum tau txais ib daim ntawv me me, uas nthuav tawm cov ntaub ntawv compressed rau txhua qhov ntsuas los ntawm cov thawj array. Cov txheej txheem ntawm kev tshawb nrhiav qhov tseem ceeb nrog cov duab sib xws tau tham hauv kev nthuav dav saum toj no.