Excel yog feem ntau yog ib qhov kev pab cuam rau kev ua cov ntaub ntawv uas nyob hauv lub rooj. Qhov kev ua haujlwm VIEW pom cov nqi ntawm qhov kev xav tau, ua qhov kev teev npe kom paub zoo uas muaj nyob hauv tib lub kab lossis sab. Yog li, piv txwv li, koj tuaj yeem tso saib tus nqi ntawm ib yam khoom nyob rau hauv ib lub xov tooj ntawm tes, qhia nws lub npe. Ib yam li ntawd, koj tuaj yeem nrhiav tus xov tooj ntawm tus neeg lub npe. Cia wb mus saib zoo li cas lub NTSUAB saib ua haujlwm li cas.
Daim ntawv thov tus neeg tsav tsheb VIEW
Ua ntej koj pib siv lub LOOKUP cuab tam, koj yuav tsum tsim ib lub rooj, qhov twg yuav muaj qhov tseem ceeb uas koj yuav tsum tau nrhiav thiab teev qhov tseem ceeb. Raws li cov ciaj ciam no, qhov kev tshawb no yuav raug muab coj los. Muaj ob txoj hauv kev los siv kev ua haujlwm: ib hom vector thiab ib qho qauv duab.
Txoj kev cai 1: Daim qauv ntawm daim duab
Hom no feem ntau siv cov neeg siv thaum siv tus LOOKUP tus neeg teb xov tooj.
- Kom yooj yim, peb tsim ib lub rooj thib ob nrog txhua kab "Xav kom tus nqi" thiab "Tshwm sim". Qhov no tsis tsim nyog, vim rau cov laj thawj no koj tuaj yeem siv cov hlwb hauv daim ntawv. Tab sis nws yuav yooj yim dua.
- Xaiv lub xovtooj ntawm tes uas qhov kawg yuav tshwm. Nyob rau hauv nws yuav yog tus qauv nws tus kheej. Ndliv qhov icon "Ntxig rau kev ua haujlwm".
- Lub qhov rais Wizard opens. Hauv daim ntawv peb tab tom nrhiav ib yam khoom "PROSMOTR" xaiv nws thiab nyem rau ntawm lub pob "OK".
- Tom ntej, qhib qhov rais ntxiv. Hauv lwm cov tswv, nws yog qhov tsawg. Ntawm no koj yuav tsum xaiv ib hom ntawm cov ntaub ntawv cov ntaub ntawv uas tau muab los tham saum toj no: vector lossis array form. Txij li thaum peb tab tom xav txog raws nraim li vector saib, peb xaiv thawj qhov kev xaiv. Peb nias lub khawm "OK".
- Lub qhov rais qhib qhov rooj. Raws li koj tau pom, qhov kev ua no muaj peb nqe lus:
- Suav tus nqi;
- Saib vector;
- Ntsiab vector.
Rau cov neeg siv uas xav siv tus neeg teb xov tooj manually, tsis tas siv "Masters ntawm kev ua haujlwm", nws yog ib qho tseem ceeb kom paub cov syntax ntawm nws txoj kev sau ntawv. Nws zoo li no:
= Saib (nrhiav nqi, saib pom vector, ua vector)Peb yuav tsom rua qhov tseem ceeb uas yuav tsum tau nkag rau hauv qhov rais ntawm cov lus sib cav.
Hauv teb "Xav kom tus nqi" nkag mus rau qhov chaw ntawm lub xov tooj ntawm tes uas peb yuav sau qhov parameter uas yuav raug tshawb. Peb nyob rau hauv lub thib ob lub rooj muaj npe li ntawd cais lub xov tooj ntawm tes. Raws li ib txwm, qhov chaw nyob ntawm qhov txuas yog nkag hauv thaj teb los ntawm kev xuas tes los ntawm cov keyboard lossis los ntawm qhov tseem ceeb cheeb tsam. Qhov kev xaiv thib ob tau yooj yim dua.
- Hauv teb "Saib Vector" hais kom meej cov kab kev ntawm cov hlwb, thiab nyob rau hauv peb cov ntaub ntawv, kem qhov twg cov npe, ib tus uas yuav muab kaw rau hauv xov tooj cua "Xav kom tus nqi". Nkag mus rau qhov chaw khiav hauj lwm hauv daim teb no yog qhov yooj yim tshaj yog xaiv qhov chaw ntawm daim ntawv.
- Hauv teb "Ntsiab Vector" nkag mus rau qhov chaw ntawm qhov ntau qhov twg qhov tseem ceeb uas peb yuav tsum tau nrhiav yog nyob.
- Tom qab tag nrho cov ntaub ntawv nkag, nyem rau ntawm lub pob "OK".
- Tab sis, raws li peb tau pom, yog li deb lub txiaj ntsim tau qhia txog qhov tsis yog nyob ntawm tes. Hauv kev txiav txim rau nws pib ua hauj lwm, ib tug yuav tsum nkag mus rau qhov parameter uas peb xav tau los ntawm cov vector raug saib nyob rau hauv thaj tsam ntawm yam nqi.
Tom qab cov ntaub ntawv tau raug ntaus, lub xov tooj ntawm tes uas qhov kev ua haujlwm nyob ntawd tau sau nrog qhov kev ntsuas ntawm qhov vector.
Yog tias peb nkag mus rau lwm lub npe nyob rau hauv lub xovtooj ntawm qhov nqi txaus siab, ces qhov tshwm sim, yuav tsum hloov.
VIEWER muaj nuj nqi zoo ib yam li CDF. Tiam sis hauv CDF, txoj kev saib xyuas sab nraud yuav tsum yog qhov seem tshaj plaws. Ntawm LOOKUP qhov kev txwv no tsis tuaj yeem tsis tuaj kawm ntawv, raws li peb pom hauv qhov qauv saum toj no.
Tshooj: Excel Function Wizard
Txoj kev 2: daim ntawv array
Tsis zoo li yav dhau los, daim ntawv no ua haujlwm nrog ib qho tseemceeb, uas tam sim ntawd nrog rau ntau qhov kev pom thiab qhov ntau ntawm kev tshwm sim. Nyob rau tib lub sij hawm, qhov khwv yees tau yuav tsum tau yog qhov seem sab nrauv ntawm qhov array.
- Tom qab lub xov tooj ntawm qhov chaw uas yuav tshwm sim tau raug xaiv, tus Xib Hwb ntawm kev khiav dej num yog pib thiab qhov kev hloov mus rau tus neeg teb xov tooj SAIB no, lub qhov rais qhib rau xaiv tus neeg teb xov tooj. Hauv qhov no, xaiv hom neeg teb xov tooj rau qhov array, uas yog, qhov thib ob txoj hauj lwm hauv daim ntawv. Peb nias "OK".
- Lub qhov rais qhib qhov rooj. Raws li koj tau pom, qhov subtype ntawm kev ua muaj tsuas yog ob nqe lus - "Xav kom tus nqi" thiab "Array". Raws li, nws cov syntax yog raws li nram no:
= VIEWER (lookup_value; array)Hauv teb "Xav kom tus nqi"raws li nyob rau hauv txoj kev dhau los, nkag rau ib qho ntawm lub xov tooj ntawm tes uas cov lus nug yuav raug ntaus.
- Tab sis nyob hauv daim teb "Array" koj yuav tsum qhia kom meej txog cov hauj lwm ntawm tag nrho cov array, uas muaj ob qho tib si raug saib thiab qhov ntau ntawm cov ntsiab lus. Nyob rau tib lub sijhawm, qhov khwv yees tau yuav tsum tau yog qhov seem sab qab ntawm cov array, txwv tsis pub cov mis mos yuav tsis ua hauj lwm zoo.
- Tom qab cov ntaub ntawv teev npe nkag, sau rau ntawm lub pob "OK".
- Tam sim no, zoo li lub sij hawm dhau los, yuav kom siv qhov kev ua haujlwm no, hauv xovtooj rau yam nqi, sau ib lub npe ntawm cov kev saib xyuas ntau.
Raws li koj tau pom, tom qab qhov no, qhov tshwm sim tau pom tshwm ntsej muag nyob rau cheeb tsam ua ke.
Mloog zoo! Nws yuav tsum raug sau tseg tias daim ntawv ntawm QHOV QHIA rau qhov array tsis dhau. Nyob rau hauv tshiab versions of Excel, nws yog tam sim no, tab sis sab laug xwb rau compatibility nrog cov ntaub ntawv ua nyob rau hauv dhau los versions. Txawm hais tias nws muaj peev xwm siv ib daim ntawv tuaj rau hauv cov niaj hnub piv txwv ntawm qhov kev zov me nyuam, nws raug pom zoo es tsis txhob siv cov CDF ntau dua kev ua haujlwm (rau kev tshawb nrhiav hauv thawj kab ntawm ib thaj tsam) thiab GPR (rau kev tshawb nrhiav ntawm thawj kab ntawm ib qhov chaw). Lawv yog cov tsis muaj kev tsis sib thooj ntawm cov kev ua haujlwm ntawm KEV QHIA DAWB rau cov arrays, tab sis lawv ua hauj lwm ntau dua. Tab sis tus vector tus neeg tsav tsheb VIEW tseem tseem ceeb.
Tshooj: Piv txwv ntawm cfr kev ua haujlwm hauv Excel
Raws li koj tau pom, tus neeg teb xov tooj SAIB yog ib tus neeg pabcuam zoo thaum nws nrhiav cov ntaub ntawv ntawm qhov nqi. Qhov no feature yog tshwj xeeb tshaj yog tseem ceeb nyob rau hauv ntev tables. Nws kuj tseem yuav tsum tau sau tseg tias muaj ob hom ntawm qhov kev ua no - vector thiab rau cov arrays. Qhov kawg yog ib qho dhau los. Txawm hais tias qee cov neeg siv, nws siv kom deb li deb.
