Raws li koj paub, Excel muaj ntau yam cuab yeej rau kev ua haujlwm nrog cov qauv. Ib tug ntawm lawv yog qhov ua haujlwm ntawm MUMMY. Nrog rau tus neeg teb xov tooj no, cov neeg siv muaj lub sijhawm los muab ntau yam sib txawv. Cia peb kawm paub siv txoj haujlwm no hauv kev xyaum, thiab lub luag haujlwm ntawm kev ua haujlwm zoo licas.
Siv tus neeg teb xov tooj mummy
Lub ntsiab haujlwm ntawm txoj haujlwm Mummy, raws li tau hais los saum no, yog qhov sib npaug ntawm ob qho kev ntsuas. Nws yog nyob rau pawg ntawm cov tswvcuab lej.
Lub syntax rau no muaj nuj nqi raws li nram no:
= MUMNAGE (array1; array2)
Raws li koj tau pom, tus neeg teb xov tooj tsuas muaj ob nqe lus - "Massive1" thiab "Massiv2". Txhua ntawm cov lus sib cav yog qhov txuas rau ib qho ntawm cov qauv, uas yuav tsum tau hloov. Qhov no yog raws nraim li cov lus saum toj no.
Ib qho tseem ceeb ua ntej thov Mummy yog tias cov naj npawb ntawm thawj daim duab yuav tsum yog qhov sib npaug ntawm txhua kab ob. Txwv tsis pub, qhov tshwm sim ntawm kev ua yuav yog qhov yuam kev. Tsis tas li, kom tsis txhob raug, tsis muaj ib qho ntawm ob qho tib si ntawm txhua tus arrays yuav tsum tsis muaj dab tsi, tab sis lawv yuav tsum muaj cov lej nkaus xwb.
Matrix kev sib npaug
Tam sim no cia wb ib qho piv txwv xav txog seb koj yuav ua li cas muab tau ob qho matrices los ntawm kev thov tus neeg teb xov tooj Mummy.
- Peb qhib cov ntawv Excel, uas ob lub cim uas muaj ob lub. Peb xaiv ntawm nws ib thaj chaw ntawm khoob hlwb, uas horizontally muaj tus naj npawb ntawm cov kab ntawm thawj tus matrix, thiab vertically ntawm tag nrho cov kab ntawm ob sab. Tom ntej, nyem rau ntawm lub cim "Ntxig rau kev ua haujlwm"uas yog nyob ze ntawm lub mis bar.
- Tua tawm tshwm sim Muaj nuj nqi masters. Peb yuav tsum mus rau pawg "Lej" los yog "Daim ntawv teev npe tag nrho". Nyob rau hauv daim ntawv teev cov neeg tsav tsheb yuav tsum nrhiav lub npe "MUMNOZH", xaiv nws thiab nias lub khawm "OK"uas yog nyob hauv qab ntawm qhov rai no.
- Cov neeg teb xov tooj pib qhib qhov rooj. Mummy. Raws li koj tau pom, nws muaj ob chav: "Massive1" thiab "Massiv2". Nyob rau ntawm thawj koj yuav tsum qhia kom meej txog qhov ntawm qhov thawj tus cim, thiab hauv ob, feem ntau, qhov thib ob. Yuav kom ua tau li no, teem tus cursor hauv thawj daim teb. Tom qab ntawd peb ua ib tug clamp nrog rau sab laug nas khawm thiab xaiv lub cheeb tsam ntawm cheeb tsam uas muaj thawj matrix. Tom qab ua tiav txoj kev ua yoojyim, qhov chaw ua haujlwm yuav tshwm sim nyob rau lub tshav puam xaiv. Peb nqa tawm ib qho kev ua zoo sib xws nrog ob lub teb, tsuas yog lub sij hawm no xwb, tuav cov laug nas khawm, xaiv thib ob ntawm qhov loj.
Tom qab ob qhov chaw nyob ntawm ob qho ntawv sau, tsis txhob maj mus nias lub khawm "OK"muab tso rau hauv qab ntawm qhov rais. Lub point yog tias peb tabtom soj ntsuam nrog ib qho kev ua tus array. Nws qhia hais tias qhov tshwm sim tsis yog tshwm sim nyob rau hauv ib lub xov tooj ntawm tes, raws li nyob rau hauv dog dig functions, tab sis tam sim ntawd mus rau ib tug tag nrho ntau. Yog li ntawd, los tso saib tag nrho cov ntaub ntawv ua tiav kev siv tus neeg teb xov tooj, nws tsis txaus rau nias qhov Saulos ntawm qhov muab tus cursor hauv lub voj voos, los yog nias rau ntawm lub pob "OK", nyob hauv cov lus sib tham ntawm qhov haujlwm uas tam sim no qhib rau peb. Yuav tsum tau siv tus yuam sij Ctrl + ua haujlwm + nkag. Ua cov txheej txheem no, thiab khawm "OK" tsis txhob kov.
- Raws li koj tau pom, tom qab koj nias qhov tseem ceeb ntawm cov neeg teb xov tooj sib tham Mummy kaw, thiab qhov ntau ntawm cov hlwb, uas peb tau pom nyob hauv thawj kauj ruam ntawm txoj kev qhia no, tau sau nrog cov ntaub ntawv. Nws yog cov kev ntseeg no uas yog tshwm sim los ntawm kev sib txuam ib qhov kev sib tw ntawm lwm tus, uas tus neeg teb xov tooj tau ua Mummy. Raws li koj tau pom, qhov kev ua yog muab rau hauv nkhaus khov hauv qhov formula formula, uas txhais tau hais tias nws yog cov tswv lagluam.
- Tab sis raws nraim li cas ntawm cov ua haujlwm Mummy yog cov khoom tsim, tiv thaiv ntxiv yog tias tsim nyog. Yog tias koj sim hloov cov nab npawb ntawm cov txiaj ntsim kawg, tus neeg siv yuav tos txog cov lus uas qhia rau koj tias koj tuaj yeem hloov tsis tau ib qho ntawm cov array. Txhawm rau tshem tawm qhov txaav no thiab hloov cov qauv ntu immutable mus rau ib qho ntau ntawm cov ntaub ntawv uas koj tuaj yeem ua haujlwm nrog, ua cov kauj ruam nram qab no.
Xaiv qhov ntau yam thiab, nyob hauv tab "Tsev", nyem rau ntawm lub cim "Daim qauv"uas yog nyob rau hauv lub cuab yeej thaiv "Ntawv Teev Npe". Ntxiv thiab, es tsis txhob siv lub lag luam no, koj tuaj yeem siv qhov txheej txheem Ctrl + C.
- Tom qab ntawd, tsis tas tshem qhov kev xaiv ntawm qhov ntau, nyem rau ntawm nws txoj kev nas khawm. Nyob rau hauv lub ntsiab lus teb qhib lub ntsiab lus teb nyob rau hauv lub block "Insertion Options" xaiv ib yam khoom "Qhov tseem ceeb".
- Tom qab ua tiav qhov kev ua no, qhov kev sib tw zaum kawg yuav tsis tuaj yeem sawv cev tam li ib qho kev tsis sib npaug uas tsis muaj qhov sib txawv thiab ntau yam kev ua haujlwm tau nrog nws.
Tshooj: Ua haujlwm nrog arrays hauv Excel
Raws li koj tau pom, tus neeg teb xov tooj Mummy tso cai rau koj kom sai thiab yooj yim muab ob qho matrices rau hauv txhua lwm hauv Excel. Lub syntax ntawm no muaj nuj nqi heev thiab cov neeg siv yuav tsum tsis txhob muaj teeb meem nkag cov ntaub ntawv hauv qhov kev sib cav qhov rai. Qhov teeb meem tsuas yog tshwm sim thaum ua hauj lwm nrog tus neeg teb xov tooj yog tias nws yog ib qho muaj nuj nqi, uas txhais tau tias nws muaj qee nta. Kom tawm cov txiaj ntsig zoo, koj yuav tsum xub xaiv cov nqe lus tsim nyog rau ntawm daim ntawv, thiab tom qab ntawd nkag mus rau cov lus sib tham rau kev xam siv ib qho tseem ceeb tseem ceeb ua ke tsim haujlwm nrog hom ntaub ntawv no - Ctrl + ua haujlwm + nkag.
