thaum ua haujlwm ntawm Google Sheets Koj tuaj yeem hla cov ntawv loj loj uas koj yuav tsum tau ua nrog ntau qhov sib npaug.
Peb nkag siab qhov nyuaj ntawm kev soj ntsuam cov duplicates thiab nws yuav nyuaj npaum li cas yog tias koj tseem ceeb thiab tshem tawm ib qho los ntawm ib qho.
Txawm li cas los xij, nrog kev pab Kev cai Formatting Kos thiab tshem tawm duplicates yuav yooj yim heev.
Whereas conditional formatting ua rau nws yooj yim heev kom paub qhov txawv duplicates hauv Google Ntawv.
Ua raws li cov lus qhia no thaum peb qhia koj yuav ua li cas thiaj nrhiav tau thiab tshem tawm cov khoom sib xws hauv Google Sheets.
Txhua yam nws yuav siv yog ob peb nias kom tshem tawm cov duplicates hauv Google Sheets thiab cia peb paub lawv.
Google Sheets: Yuav ua li cas kom pom cov duplicates hauv ib kab
ua ntej paub Yuav ua li cas tshem tawm duplicate nkag من phau ntawv Google Cia peb kawm paub qhov txawv cov duplicates hauv ib kab. Ua raws li cov kauj ruam no.
- Qhib cov ntawv nthuav dav hauv Google Sheets thiab xaiv ib kab.
- Piv txwv li, xaiv Kem A > Sib koom tes > Sib koom tes Tub ceev xwm .
- Hauv kev cai Formatting, qhib cov ntawv qhia zaub mov thiab xaiv Cov qauv kev cai yog .
- Sau tus nqi ntawm cov qauv kev cai, = countif(A1: A, A1) > 1 .
- Nyob rau hauv Cov Cai Txheej Txheem, koj tuaj yeem pom Cov Qauv Hom, uas tso cai rau koj los muab cov xim sib txawv rau cov ntawv tseem ceeb. Txhawm rau ua qhov no, coj mus rhaub rau ntawm lub cim Sau xim Thiab xaiv koj nyiam ntxoov ntxoo.
- Thaum ua tiav, nias ua li cas أو م Txhawm rau nthuav cov duplicates hauv ib kab.
- Ib yam li ntawd, yog tias koj yuav tsum ua qhov no rau kab C, cov qauv ua, = countif(C1:C,C1)>1 and will Yog li kuj rau lwm kab.
Tsis tas li ntawd, muaj ib txoj hauv kev los nrhiav cov duplicates hauv nruab nrab ntawm kab thiab. Yog xav kawm, ua raws li cov kauj ruam no.
- Cia peb hais tias koj xav qhia qhov sib npaug ntawm cov hlwb C5 rau C14.
- Hauv qhov no, mus rau Sib koom tes thiab xaiv xwm txheej formatting .
- Nyob rau hauv Apply to scope, enter data range, C5: ua 14 .
- Tom ntej no, nyob rau hauv Formatting txoj cai, qhib lub drop-down ntawv qhia zaub mov thiab xaiv Cov qauv kev cai yog .
- Sau tus nqi ntawm cov qauv kev cai, = countif(C5:C,C5)>1 .
- Yog tias xav tau, muab cov xim sib txawv rau qhov tseem ceeb duplicates los ntawm kev ua raws cov kauj ruam dhau los. Thaum ua tiav, nias م .
- Yog tias xav tau, muab cov xim sib txawv rau qhov tseem ceeb duplicates los ntawm kev ua raws cov kauj ruam dhau los. Thaum ua tiav, nias م .
Google Sheets: Yuav ua li cas pom cov duplicates hla ntau kab
Tsuas yog nyob rau hauv cov ntaub ntawv koj xav cim duplicates hla ntau kab thiab kab, ua raws cov kauj ruam no.
- Qhib cov ntawv nthuav dav hauv Google Sheets thiab xaiv ntau kab.
- Piv txwv li, xaiv kab B txog E > nyem hom > Nyem xwm txheej formatting .
- Hauv kev cai Formatting, qhib cov ntawv qhia zaub mov thiab xaiv Cov qauv kev cai yog .
- Sau tus nqi ntawm cov qauv kev cai, = countif (B1: E, B1) > 1 .
- Yog tias xav tau, muab cov xim sib txawv rau qhov tseem ceeb duplicates los ntawm kev ua raws cov kauj ruam dhau los. Thaum ua tiav, nias م .
- Ib yam li ntawd, yog tias koj xav qhia qhov tshwm sim ntawm kab M mus rau P, koj hloov B1 nrog M1 thiab E nrog P. Cov qauv tshiab dhau los, = countif(M1:P,M1)>1 .
- Tsis tas li ntawd, yog tias koj xav cim qhov tshwm sim ntawm txhua kab ntawm A txog Z, tsuas yog rov ua cov kauj ruam dhau los thiab sau tus nqi rau cov qauv kev cai, = countif (A1: Z, A1) > 1 .
Google Sheets: Tshem cov duplicates ntawm koj daim ntawv nthuav qhia
Tom qab koj tau ua tiav qhov tseem ceeb ntawm cov khoom sib npaug hauv daim ntawv nthuav qhia, cov kauj ruam tom ntej yog rho tawm lawv. Ua raws li cov kauj ruam no.
- Xaiv lub kem uas koj xav kom tshem tawm duplicates.
- Nyem cov ntaub ntawv > tshem tawm cov duplicates .
- Tam sim no koj yuav pom ib tug popup. muab ib qho cim Hauv lub thawv ib sab ntawm cov ntaub ntawv muaj lub taub hau tam sim no> nyem duplicate tshem tawm > Nyem م .
- Koj tuaj yeem rov ua cov kauj ruam rau lwm kab.
Nov yog qhov koj tuaj yeem kos thiab tshem tawm cov duplicates hauv Google Ntawv.
