Thaum ua haujlwm nrog tib cov ntaub ntawv tso rau hauv cov ntawv sib txawv, cov ntawv txheeb, lossis txawm tias cov phau ntawv, rau qhov yooj yim ntawm kev nkag siab nws yog qhov zoo dua los khaws cov ntaub ntawv ua ke. Hauv Microsoft Excel, koj tuaj yeem tiv nrog txoj haujlwm no uas siv cov cuab yeej tshwj xeeb hu ua "kev sib sau ua ke". Nws muab lub peev xwm los sau cov ntaub ntawv tsis sib xws rau hauv ib lub rooj. Cia peb kawm seb nws ua tiav li cas.
Cov xwm txheej rau kev siv ntawm cov txheej txheem consolidation
Lawm, tsis yog txhua lub rooj zaum tuaj yeem ua ke ua ke rau hauv ib qho, tab sis tsuas yog cov uas sib haum rau qee yam mob:- Txhua hauv txhua lub rooj yuav tsum muaj tib lub npe (tsuas yog permutation ntawm kab hauv cov chaw);
- Yuav tsum tsis muaj chaw lossis cov kab uas muaj cov nuj nqis khoob;
- Cov qauv hauv cov rooj yuav tsum yog tib yam.
Tsim cov rooj sib sau ua ke
Xav txog yuav ua li cas los tsim cov rooj sib xyaw ua ke ntawm cov piv txwv ntawm peb cov kab muaj tib qauv qauv thiab cov ntaub ntawv. Txhua ntawm lawv nyob rau ntawm ib daim ntawv me me, txawm hais tias nyob rau tib lub algorithm koj tuaj yeem tsim cov lus sib xyaw ua ke los ntawm cov ntaub ntawv uas muaj nyob hauv cov ntaub ntawv sib txawv (cov ntaub ntawv).
- Qhib ib daim ntawv cais rau cov rooj sib xyeem.
- Nyob rau daim ntawv qhib, peb cim lub cell uas yuav yog sab sauv sab sauv ntawm lub rooj tshiab.
- Ua nyob rau hauv "Data" tab los txhaj rau "Consolidation" khawm, uas nyob ntawm daim kab xev hauv "Ua haujlwm nrog cov ntaub ntawv" toolbar.
- Ib cov ntaub ntawv sib dhos teeb tsa lub qhov rais qhib.
Nyob rau hauv "Function" teb, koj yuav tsum tsim cov kev ua uas cov hlwb yuav ua thaum cov kab thiab kab sib phim. Cov no yuav yog cov kev coj ua hauv qab no:
- suav;
- tus naj npawb;
- qhov nruab nrab;
- siab kawg;
- yam tsawg kawg;
- ua haujlwm;
- tus nqi ntawm cov naj npawb;
- kev tshem tawm;
- tsis ruaj khov;
- Displaced dispersion;
- Unbelled dispersion.
Feem ntau, qhov "tus nqi" tau siv.
- Hauv qhov link teb, qhia meej cov kab ntawm cov hlwb ntawm ib qho ntawm thawj cov rooj uas muaj kev sib sau ua ke. Yog tias muaj ntau yam no yog nyob rau hauv tib daim ntawv, tab sis nyob rau lwm daim ntawv, tom qab ntawd nias lub pob uas nyob rau sab xis ntawm cov ntaub ntawv nkag teb chaws.
- Mus rau hauv daim ntawv nyob qhov twg lub rooj nyob, hais txog cov kev xav tau. Tom qab nkag mus rau cov ntaub ntawv, peb nyem dua ntawm lub pob nyob rau sab xis ntawm daim teb uas qhov chaw nyob ntawm lub hlwb ntxiv.
- Rov qab los rau cov chaw sib sau ua ke los ntxiv cov cell uas tau xaiv mus rau cov npe ntawm bands, nyem rau ntawm Add khawm.
Raws li koj tuaj yeem pom, tom qab qhov no, cov ntau tau ntxiv rau hauv cov npe.
Ib yam li ntawd, ntxiv tag nrho lwm cov neeg uas yuav koom nrog cov txheej txheem ntawm cov ntaub ntawv kev sib sau ua ke.
Yog tias cov kev xav tau tau muab tso rau hauv lwm phau ntawv (ua ntawv), tom qab ntawd peb tau nias lub ntsej muag thiab tshem tawm cov xov xwm lossis tshem tawm cov xov xwm ntawm cov hlwb Cov ntaub ntawv no. Lawm, cov ntaub ntawv yuav tsum qhib.
- Ib yam li ntawd, qee qhov kev sib sau ua ke rooj zaum tuaj yeem ua tau.
Txhawm rau kom tau ntxiv lub npe ntawm cov kab ntawv rau cov header, peb muab tus zuam nyob ze "kos npe ntawm kab sab saum toj". Txhawm rau ua kom ua tiav cov ntaub ntawv ntawm cov ntaub ntawv, peb tau teem tus zuam txog "sab laug" parameter. Yog tias koj xav tau, thaum cov ntaub ntawv hloov kho tshiab hauv cov lus tseem ceeb, txhua yam ntaub ntawv nyob rau hauv lub cim consolidated kuj tau hloov kho, ces koj yuav tsum nruab cov cim kos nyob ze ntawm "Tsim kev sib txuas lus nrog cov ntaub ntawv zoo" parameter. Tab sis, nyob rau hauv cov ntaub ntawv no, nws yog ib qho yuav tsum tau xav tau tias yog tias koj xav ntxiv cov kab tshiab rau cov khoom siv, koj yuav tsum tau tshem tawm cov qauv ntawm cov khoom no thiab rov muab cov nqi ntawm tus kheej.
Thaum txhua qhov chaw tau ua, nyem rau ntawm "OK" khawm.
- Daim Ntawv Tshaj Qhia Consolidated yog npaj txhij. Raws li koj tuaj yeem pom, cov ntaub ntawv tau ua pawg. Txhawm rau saib cov ntaub ntawv hauv txhua pab pawg, nyem rau ntawm lub luag haujlwm ntxiv rau sab laug ntawm rooj.
Tam sim no cov ntsiab lus ntawm cov pab pawg muaj rau saib. Ib yam li ntawd, koj tuaj yeem qhia lwm pab pawg.
Raws li koj tuaj yeem pom, kev sib xyaw ua ke ntawm cov ntaub ntawv hauv Excel yog qhov khoom siv yooj yim, ua tsaug rau cov ntaub ntawv sib txawv thiab ntawm cov ntaub ntawv sib txawv, tab sis txawm muab tso rau lwm cov ntaub ntawv (cov ntawv). Nws yog qhov yooj yim thiab nrawm.