Qhov wikiHow qhia koj li cas los xaiv cov xov tooj ntawm tes hauv Excel daim ntawv nthuav qhia, thiab suav tus lej ntawm txhua lub xov tooj ntawm tes nrog cov ntawv hauv lawv, siv computer.
Cov kauj ruam
Kauj Ruam 1. Qhib Excel cov ntaub ntawv koj xav kho hauv koj lub computer
Koj tuaj yeem qhib Microsoft Excel thiab nrhiav koj cov ntaub ntawv ntawm daim ntawv teev npe uas tau khaws tseg, lossis tsuas yog ob npaug nias rau cov ntawv kom qhib nws.
Kauj Ruam 2. Nyem rau ntawm tes tsis muaj dab tsi
Nrhiav ib lub xov tooj uas tsis muaj dab tsi los ntxig koj cov lej suav, thiab nyem rau nws.
Kauj Ruam 3. Hom = COUNTIF (thaj tsam, cov txheej txheem) hauv lub cell khoob
Cov mis no yuav tso cai rau koj xaiv ntau lub xov tooj ntawm tes, thiab suav tus lej ntawm cov cell nrog cov ntawv hauv lawv.
Kauj Ruam 4. Hloov ntau yam nrog cov xov tooj ntawm tes uas koj xav suav
Nkag mus rau koj thawj zaug thiab zaum kawg ntawm kab ntawv ntawm no, cais los ntawm txoj hnyuv.
Piv txwv li, yog tias koj suav cov cell A1 txog D6, sau A1: D6 ntawm no
Kauj Ruam 5. Hloov cov qauv nrog "*" hauv cov mis
Qhov no yuav suav tus lej ntawm txhua lub cell nrog cov ntawv hauv kab ntawv xaiv.
Piv txwv li, yog tias koj suav cov cell A1 txog D6, koj cov mis kawg yuav tsum zoo li = COUNTIF (A1: D6, "*")
Kauj Ruam 6. Nias ↵ Enter los yog ⏎ Rov qab los ntawm koj cov keyboard.
Qhov no yuav siv tus qauv, thiab suav koj cov cell. Tus naj npawb ntawm cov cell nrog cov ntawv hauv qhov xaiv tau yuav tshwm nyob rau hauv cov qauv ntawm tes.