Yuav Paub
- Highib ib kab. Xaiv Format > Conditional Formatting. Xaiv tus qauv kev cai yog hauv hom kab mob yog ntawv qhia.
- Tom qab ntawd, nkag mus =countif(A:A, A1)>1 (kho cov ntawv rau kab ke xaiv). Xaiv ib qho color hauv ntu Formatting Style.
- Lwm txoj hauv kev: Siv cov qauv UNIQUE lossis ntxiv rau.
Kab lus no piav qhia yuav ua li cas kom pom cov duplicates hauv Google Sheets siv peb txoj hauv kev.
Yuav ua li cas thiaj nrhiav tau qhov sib npaug hauv Google Cov Ntawv Kab
Ib txoj hauv kev los txheeb xyuas qhov sib npaug yog kom pom lawv nrog xim. Koj tuaj yeem tshawb nrhiav los ntawm kab ntawv rau qhov sib npaug thiab txiav txim siab rau lawv, los ntawm kev sau cov hlwb nrog cov xim lossis hloov cov ntawv xim.
- Qhib daim ntawv qhia koj xav txheeb xyuas hauv Google Sheets.
- Ua kom daim ntawv nthuav qhia muaj cov ntaub ntawv teeb tsa los ntawm txhua kab thiab txhua kem muaj ib nqe lus.
- Highlight kab koj xav tshawb.
-
Click Format > Conditional Formatting. Lub Conditional Formatting zaub mov qhib ntawm sab xis.
Image - Qhia cov xov tooj ntawm tes yog yam koj xaiv hauv Kauj Ruam 2.
-
In the Format cells if drop-down menu, xaiv Custom formula is. Ib daim teb tshiab tshwm hauv qab nws.
-
Nkag mus rau cov qauv hauv qab no hauv daim teb tshiab, kho cov ntawv rau kab kab uas koj xaiv:
=countif(A:A, A1)>1
Image -
Nyob rau hauv Formatting style ntu, xaiv cov xim sau rau cov hlwb sib npaug. Hauv qhov piv txwv no, peb tau xaiv liab.
Image Xwb, koj tuaj yeem hloov cov xim ntawm cov ntawv hauv cov hlwb sib npaug es tsis txhob sau nws nrog xim. Txhawm rau ua qhov no, xaiv lub ntawv ximicon (tus A hauv cov ntawv qhia zaub mov) thiab xaiv koj cov xim.
-
Xaiv Done txhawm rau siv cov kev cai formatting. Tag nrho cov duplicates tam sim no yuav tsum muaj lub xov tooj liab puv.
Image
Nrhiav Duplicates hauv Google Sheets Nrog Formula
Koj tuaj yeem siv tus qauv los nrhiav cov ntaub ntawv sib npaug hauv koj daim ntawv nthuav qhia. Txoj kev no tuaj yeem ua haujlwm los ntawm kab lossis los ntawm kab thiab qhia cov ntaub ntawv sib npaug hauv kab tshiab lossis ntawv hauv koj cov ntaub ntawv.
Nrhiav duplicates hauv kab nrog tus qauv
Nrhiav duplicates hauv txhua kab cia koj tshuaj xyuas ib kem ntawm cov ntaub ntawv saib seb puas muaj dab tsi hauv kem uas tau muab duplicated.
- Qhib daim ntawv qhia koj xav txheeb xyuas.
- Nias rau hauv lub xov tooj qhib hauv tib daim ntawv (piv txwv li, kab ntawv khoob tom ntej hauv daim ntawv).
-
Nyob hauv lub cell uas khoob, nkag mus rau hauv qab no thiab nias Enter.
=UNIQUE
Tus qauv qhia tau qhib.
-
Xaiv kab uas koj xav pom duplicates hauv los ntawm nias tsab ntawv nyob rau sab saum toj ntawm kab. Cov qauv yuav cia li ntxiv cov kab ke rau koj. Koj cov qauv yuav zoo li no:
=UNIQUE(C2:C25)
Image -
Hloov lub kaw lus nyob rau hauv cov qauv cell (los yog nias Enter) kom tiav cov qauv.
Image -
Cov ntaub ntawv tshwj xeeb tau tshwm sim hauv kab ntawv rau koj, pib ntawm lub xov tooj uas koj nkag mus rau cov qauv.
Image
Nrhiav kab sib tshooj siv tus qauv
Txoj kev los nrhiav cov kab sib npaug hauv koj daim ntawv tshaj tawm zoo ib yam, tshwj tsis yog qhov ntau ntawm cov hlwb koj xaiv los txheeb xyuas los ntawm cov qauv sib txawv.
- Qhib daim ntawv qhia koj xav txheeb xyuas.
- Nias rau hauv lub xov tooj qhib hauv tib daim ntawv (piv txwv li, kab ntawv khoob tom ntej hauv daim ntawv).
-
Nyob hauv lub cell uas khoob, nkag mus rau hauv qab no thiab nias Enter.
=UNIQUE
Tus qauv qhia tau qhib.
- Xaiv kab koj xav txheeb xyuas kom duplicates.
- Nias Enter kom tiav cov qauv. Cov kab duplicate tau tshwm sim.
Nrhiav Duplicates hauv Google Sheets Nrog Ntxiv-On
Koj tseem tuaj yeem siv Google add-on txhawm rau nrhiav thiab hais txog cov duplicates hauv Google Sheets. Cov add-ons no yuav cia koj ua ntau dua nrog koj cov duplicates, xws li txheeb xyuas thiab tshem tawm lawv; sib piv cov ntaub ntawv hla cov nplooj ntawv; tsis quav ntsej header kab; cia li luam lossis txav cov ntaub ntawv tshwj xeeb mus rau lwm qhov chaw; thiab ntau dua.
Yog tias koj xav tau los hais txog ib qho ntawm cov xwm txheej no lossis yog tias koj cov ntaub ntawv teeb tsa muaj zog dua li peb kab, rub tawm Tshem Tawm Duplicates los ntawm Ablebits lossis ib qho app zoo sib xws uas tso cai rau koj nrhiav thiab qhia koj cov ntaub ntawv sib tshooj, luam cov ntaub ntawv duplicate mus rau lwm qhov chaw, thiab tshem tawm duplicate qhov tseem ceeb lossis rho tawm cov kab duplicate.
FAQ
Kuv yuav ua li cas tshem cov duplicates hauv Google Sheets?
Yuav kom tshem tawm cov duplicates hauv Google Sheets, qhib ib daim ntawv nthuav qhia thiab qhia txog cov ntaub ntawv ntau, ces mus rau Data > Data Cleanup > Tshem tawm Duplicates.
Kuv yuav piv cov ntawv sib txawv Google li cas rau qhov sib npaug?
Install Ablebit's Remove Duplicates add-on rau Google Sheets thiab siv cov cuab yeej Sib Piv Cov Ntawv lossis Cov Ntawv. Mus rau Extensions > Remove Duplicates > Piv kab los yog nplooj ntawv.
