Yuav ua li cas Muab nyob rau hauv Excel kem los ntawm kem, thiab sab rau tus xov tooj ntawm

Cov neeg uas feem ntau ua hauj lwm ntawm lub computer, ua ntej los yog tom qab tau ntsib nrog ib tug kev pab cuam xws li Excel. Tab sis qhov kev sib tham nyob rau hauv qhov tsab xov xwm mus rau tag nrho cov pros thiab cons ntawm cov kev pab cuam, thiab hais txog nws cov neeg lub Cheebtsam, "Formula". Ntawm cov hoob kawm, nyob rau hauv cov tsev kawm ntawv thiab universities rau science qhia cov menyuam kawm ntawv thiab menyuam kawm ntawv mus ib chav kawm rau cov kev kawm, tab sis rau cov neeg uas tau tsis nco qab lawm - peb cov tsab xov xwm no.

Peb yuav tham txog yuav ua li cas muab lub Excel kem rau kem. Nws yuav muab ncauj lus kom ntxaws qhia rau yuav ua li cas ua li no, nrog cov kauj ruam yog kauj ruam tsom xam ntawm txhua yam khoom, yog li ntawd txhua leej txhua tus, txawm tus novice me nyuam kawm ntawv yuav tsum tau saib mus rau qhov teeb meem.

Muab kiag los ntawm kem

Yuav ua li cas Muab nyob rau hauv Excel kem los ntawm kem, peb yuav zaum piv txwv li. Wb xav txog tej yam uas nyob rau hauv lub Excel phau koj tsim ib lub rooj nrog rau cov nqi thiab muaj nuj nqis ntawm cov khoom. Koj kuj muaj lub cell down rau tag nrho cov nqi. Raws li tej zaum koj yuav twv, koj yuav tsum ua sai sai muab thawj ob kab thiab nrhiav tau lawv sum.

Yog li ntawd, ntawm no yog cov kauj ruam yog kauj ruam cov lus qhia:

1. Thas xim rau cov kev kawm qhov chaw thiab nias lub icon muaj nuj nqi, uas yog nyob rau ntawm lub sab saum toj ntawm lub ntsiab toolbar.
2. "Lwm tus neeg" yuav tsum xaiv qhov rais tshwm nyob rau hauv pem hauv ntej ntawm koj qhov chaw uas koj xav tau.
3. Tom ntej no, koj yuav tsum xaiv los ntawm ib pawg ntawm cov zauv zog.
4. Xaiv "SUMPRODUCT".

Tom qab hais tias, ib lub qhov rais tshwm nyob rau hauv uas koj yuav tau xaiv ib tug ntau yam uas muaj cov ntaub ntawv, koj yuav tau mus ob txoj kev. Tus thawj implies hais tias koj siv cov cursor mus xaiv tus thawj kem (tus nqi), thiab nws txoj kev khwv yog teev nyob rau hauv lub "Array 1", thiab lub thib ob (nqe) - muaj npe teev nyob rau hauv lub "Array 2". Raws li koj tau pom, lub ntau yam twb teev nyob rau hauv cov cim (C2: C6). Qhov thib ob hom implies hais tias koj yuav nkag mus rau cov qhov tseem ceeb manually, qhov txawv ntawm no tsis muaj.

Tam sim no koj paub ib tug txoj kev yuav ua li cas muab nyob rau hauv Excel kem los ntawm kem, tab sis nws tsis yog qhov tsuas yog ib, thiab lub thib ob yuav tsum tau tham hereinafter.

Qhov thib ob hom ntawm kev ua lej khu

Yuav kom muab txhua ntawm lub thib ob txoj kev, koj yuav tsum tau xaiv cov kev ua pab pawg neeg "lej", tab sis tam sim no peb yuav tau siv "ua". Tam sim no muaj ob tug teb nyob rau hauv pem hauv ntej ntawm koj, "Number 1" thiab "tus xov tooj 2". Nyem rau ntawm qhov "Number 1" thiab xaiv cov thawj nqi los ntawm tus thawj kiag, zoo li rov thiab nrog rau cov "Number 2", tsuas yog xaiv tus thawj muaj nuj nqis ntawm lub thib ob kem.

Tom qab txhaj "OK" nyob rau hauv lub cell nrog rau mis yuav tsum tau cov khoom ntawm xaiv qhov tseem ceeb, tsuas tsim autofill hlwb, rau qhov no, tsiv mus nyob rau cursor mus rau lub sab ntug ntawm tus xovtooj ntawm thiab cab nws mus rau qhov yuav tsum tau cov ntsiab lus.

Tam sim no koj tau kawm ib tug thib ob txoj kev ntawm yuav ua li cas muab nyob rau hauv Excel kem los ntawm kem. Tam sim no wb tham txog yuav ua li cas muab lub xov tooj ntawm ib kem.

Muab los ntawm tus xov tooj ntawm kem

Yog li ntawd, yuav ua li cas muab ib kem nyob rau Excel rau tus xov tooj? Nyob rau hauv qhov tseeb, nws yog txawm yooj yim. Yuav kom ua li no:

1. Xaiv lub cell qhov twg tshwm sim yuav tsum tau nyob.
2. Sau nyob rau hauv nws lub kos npe rau ntawm "tib".
3. Tus cursor tseem ceeb rau hauv thawj tus nqi nyob rau hauv sab, tiam sis yuav tsum muab sau ua ke rau hauv lub xov tooj los ntawm cov uas mus muab tus nqi.
4. Tom qab ntawd, tsiv mus nyob rau cursor rau cov xov tooj thiab nias F4.
5. Nws tam sim no tseem tsuas muab tus cursor rau sab xis pem ces kaum ntawm lub cell teb thiab cab nws mus rau yam muaj nuj nqis ntawm cov khoom.