Ua ntej cov ntaub ntawv hauv Excel tuaj yeem txheeb xyuas thiab pom, nws yuav tsum tau muab ntxuav. Ib qho ntawm cov haujlwm tu huv no yog nrhiav thiab tshem tawm cov ntaub ntawv duplicate. Muaj ntau txoj hauv kev los ua kom tiav txoj haujlwm no. Kawm paub yuav ua li cas rho tawm cov duplicates hauv Excel siv lub Remove Duplicates thiab Lim cov cuab yeej. Tom qab ntawd, xaiv qhov uas ua haujlwm zoo tshaj rau koj thiab cov ntaub ntawv hauv koj daim ntawv ua haujlwm.
Cov lus qhia hauv kab lus no siv rau Excel rau Microsoft 365, Excel 2019, Excel 2016, thiab Excel 2013.
Highlight duplicate cov ntaub ntawv hauv Excel Worksheet
Yog tias koj tsuas yog xav saib cov ntaub ntawv sib npaug hauv daim ntawv ua haujlwm, taw qhia cov ntaub ntawv uas siv hom kev cai. Tom qab ntawd, yog tias koj txiav txim siab tias koj tsis xav tau cov ntaub ntawv, tshem tawm cov kab sib npaug.
-
Highlight cov ntaub ntawv koj xav tshawb nrhiav duplicates. Tsis suav nrog headers.
Image Txhawm rau qhia cov ntaub ntawv hauv daim ntawv ua haujlwm, xaiv lub xov tooj ntawm tes sab saud ntawm cov ntaub ntawv, nias thiab tuav Shift, tom qab ntawd xaiv lub xovtooj sab xis ntawm cov ntaub ntawv.
- Xaiv lub Home tab.
-
In the Styles pawg, xaiv Conditional Formatting.
Image -
Xaiv Highlight Cells Rules> Dublicate Values.
Image -
Nyob rau hauv Duplicate Values dialog box, xaiv lub values with drop-down xub thiab xaiv cov sau thiab cov ntawv xim kom pom cov duplicate rows.
Image -
Xaiv OK.
Image -
Cells uas muaj tus nqi sib npaug hauv lwm lub hlwb raug qhia.
Image - Txhawm rau tshem tawm cov kab sib tshooj hauv Excel, xaiv kab uas tseem ceeb, xaiv lub Home tab, tom qab ntawd xaiv Delete > Delete Sheet Kab. Lossis, siv cov cuab yeej tshem tawm Duplicates lossis Lim cov cuab yeej los txiav tawm Excel.
Tshem tawm cov kab sib tshooj hauv Excel sai sai
Excel tuaj yeem tshem tawm kab ntawm cov ntaub ntawv uas muaj cov ntaub ntawv zoo ib yam hauv txhua kab. Nov yog txoj hauv kev sai los ntxuav daim ntawv ua haujlwm.
Tshem tawm cov kab sib tshooj tas li tshem tawm cov ntaub ntawv. Ua ib daim ntawv ua haujlwm ua ntej yuav hloov pauv.
Siv cov cuab yeej tshem tawm Duplicates cov ntaub ntawv tshem tawm cov kab sib npaug ntawm ib daim ntawv ua haujlwm tag nrho:
-
Xaiv ib lub xovtooj hauv cov ntaub ntawv.
Image - Xaiv lub Data tab.
-
In the Data Tools pab pawg, xaiv Remove Duplicates.
Image - Nyob hauv Tshem tawm Duplicates dialog box, xaiv Xaiv Txhua.
- Xaiv lub Kuv cov ntaub ntawv muaj headers kos lub thawv yog tias daim ntawv ua haujlwm muaj cov kab ntawv kab.
-
Xaiv OK.
Image -
Nyob rau hauv cov lus uas qhia txog tus lej ntawm qhov sib npaug uas tau muab tshem tawm thiab tus lej ntawm qhov tseem ceeb uas tseem tshuav, xaiv OK.
Image -
Txhua kab zoo tib yam raug tshem tawm tsuas yog thawj qhov piv txwv ntawm cov kab sib npaug.
Image - Yog tias cov kab sib tshooj tsis raug tshem tawm raws li koj xav tau, nias Ctrl+Z txhawm rau tshem tawm cov kev hloov pauv rau daim ntawv ua haujlwm.
Tshem tawm cov ntawv sib xws hauv Excel nrog tus nqi qub hauv cov kab tshwj xeeb
Koj tuaj yeem siv cov cuab yeej tshem tawm Duplicates kom tshem tawm cov kab uas muaj nqi tib yam hauv cov kab ntawv teev tseg.
-
Xaiv ib lub xovtooj hauv cov ntaub ntawv.
Image - Xaiv lub Data tab.
-
In the Data Tools pab pawg, xaiv Remove Duplicates.
Image - Nyob hauv Tshem tawm Duplicates dialog box, xaiv Unselect All.
- Xaiv lub npov ntawm ib sab ntawm txhua kab uas koj xav tshawb nrhiav qhov sib npaug. Cov ntaub ntawv nyob rau hauv tag nrho cov xaiv kab yuav tsum duplicated rau kab yuav deleted.
- Yog tias koj daim ntawv ua haujlwm muaj kab lus, xaiv lub Kuv cov ntaub ntawv muaj headers kos lub thawv.
-
Xaiv OK.
Image -
Nyob rau hauv lub thawv ntawv lees paub, xaiv OK.
Image -
Excel tshem tawm tag nrho cov kab uas muaj cov ntaub ntawv tib yam hauv cov kab uas tau xaiv tshwj tsis yog thawj zaug ntawm cov ntaub ntawv sib npaug.
Image
Yuav ua li cas 'Rho tawm' Duplicates hauv Excel nrog Lim
Lwm txoj hauv kev los tshem tawm cov ntaub ntawv sib npaug yog lim cov ntaub ntawv kom muaj txiaj ntsig tshwj xeeb. Siv txoj kev no tsis rho tawm cov kab sib tshooj, qhov sib npaug ntawm qhov tseem ceeb tau muab zais ib ntus.
txhawm rau lim cov ntawv ua haujlwm Excel kom pom cov txiaj ntsig tshwj xeeb:
-
Xaiv ib lub xovtooj hauv cov ntaub ntawv los lim cov ntawv ua haujlwm tag nrho. Lossis, xaiv cov ntaub ntawv los lim.
Image - Xaiv lub Data tab.
-
In the Sort & Filter pawg, xaiv Advanced.
Image -
Nyob hauv Advanced Lim dialog box, xaiv lub Unique records only check box.
Txhawm rau txuag cov txiaj ntsig tau lim mus rau lwm daim ntawv ua haujlwm, xaiv Luam mus rau lwm qhov chaw.
-
Xaiv OK.
Image -
Cov duplicates raug tshem tawm.
Image - Txawm kom tshem cov lim thiab tso tawm cov ntaub ntawv qub, xaiv lub Home tab > Sort & Filter > Clear.
