Ib daim Spreadsheet tsis muaj dab tsi tab sis ib daim ntawv uas npaj cov ntaub ntawv nyob rau hauv daim ntawv ntawm kab thiab kab. Spreadsheets yog siv los ntawm yuav luag txhua lub koom haum ua lag luam los tuav nws cov ntaub ntawv khaws tseg thiab ua haujlwm ntawm cov ntaub ntawv ntawd. Txawm tias cov tsev kawm ntawv thiab cov tsev kawm ntawv qib siab siv daim ntawv teev cov software los tuav lawv cov ntaub ntawv. Thaum nws los txog rau spreadsheet software, Microsoft Excel thiab Google nplooj ntawv yog cov software saum toj kawg nkaus uas ntau tus neeg siv. Niaj hnub no, ntau tus neeg siv xaiv Google Sheets dhau Microsoft Excel raws li nws khaws cov Spreadsheets ntawm lawv Cloud Storage, piv txwv li Google Drive uas tuaj yeem nkag tau los ntawm txhua qhov chaw. Qhov tsuas yog qhov yuav tsum tau ua yog tias koj lub computer yuav tsum txuas nrog Is Taws Nem. Lwm qhov zoo ntawm Google Sheets yog tias koj tuaj yeem siv nws los ntawm koj lub qhov rais browser ntawm koj lub PC.
Thaum nws los txog rau kev tswj cov ntaub ntawv nkag, ib qho ntawm cov teeb meem tshwm sim los ntawm ntau tus neeg siv yog duplicates lossis duplicate nkag. Piv txwv li, xav txog tias koj muaj cov ntsiab lus ntawm cov neeg sau los ntawm ib daim ntawv ntsuam xyuas. Thaum koj sau lawv siv koj daim ntawv teev cov software xws li Google Sheets, muaj qhov ua tau ntawm cov ntaub ntawv sib npaug. Ntawd yog, ib tus neeg yuav tau sau daim ntawv ntsuam xyuas ntau dua ib zaug, thiab yog li Google Sheets yuav sau cov ntawv nkag ob zaug. Xws li cov khoom sib xws yog teeb meem ntau dua thaum nws los txog rau kev lag luam. Xav txog yog tias kev hloov pauv nyiaj ntsuab nkag rau hauv cov ntaub ntawv ntau dua ib zaug. Thaum koj xam tag nrho cov nuj nqis nrog cov ntaub ntawv ntawd, nws yuav yog qhov teeb meem. Txhawm rau zam qhov xwm txheej zoo li no, ib tus yuav tsum xyuas kom meej tias tsis muaj cov ntaub ntawv sib npaug hauv daim ntawv nthuav qhia. Yuav ua li cas kom ua tiav qhov no? Zoo, hauv phau ntawv qhia no, koj yuav tham txog 6 txoj hauv kev los tshem tawm cov duplicates hauv Google Sheets. Los, yam tsis muaj kev qhia ntxiv, cia peb saib rau hauv lub ncauj lus.
Cov ntsiab lus[ zais ]
- Yuav Ua Li Cas Tshem Tawm Duplicates hauv Google Sheets?
- Txoj Kev 1: Siv Cov Kev Xaiv Tshem Tawm Duplicates
- Txoj Kev 2: Tshem tawm Duplicates nrog Formulas
- Txoj Kev 3: Tshem tawm cov ntawv nkag nrog qhov xwm txheej formatting
- Txoj Kev 4: Tshem Cov Ntaub Ntawv Duplicate nrog Pivot Table
- Txoj Kev 5: Siv Apps Script
- Txoj Kev 6: Siv Add-on kom tshem tawm cov duplicates hauv Google Sheets
Yuav Ua Li Cas Tshem Tawm Duplicates hauv Google Sheets?
Duplicate cov ntaub ntawv yog qhov teeb meem tiag tiag hauv cov ntaub ntawv ntawm kev tswj cov ntaub ntawv cov ntaub ntawv. Tab sis koj yuav tsum tsis txhob txhawj vim tias koj tuaj yeem yooj yim tshem tawm cov ntawv nkag los ntawm koj li Google Sheets spreadsheet. Cia peb pom qee txoj hauv kev uas koj tuaj yeem tshem tawm cov duplicates hauv Google Sheets.
Txoj Kev 1: Siv Cov Kev Xaiv Tshem Tawm Duplicates
Google Sheets muaj qhov kev xaiv tsim los tshem tawm cov ntawv nkag uas rov ua dua (cov ntawv sau dua). Txhawm rau siv qhov kev xaiv ntawd, ua raws li cov lus piav qhia hauv qab no.
1. Piv txwv li, saib qhov no (saib screenshot hauv qab no). Ntawm no koj tuaj yeem pom tias cov ntaub ntawv Ajit tau nkag ob zaug. Qhov no yog ib daim ntawv duplicate.
2. Txhawm rau tshem tawm qhov sib npaug, xaiv los yog taw qhia cov kab thiab kab.
3. Tam sim no nyem rau ntawm cov ntawv qhia zaub mov xaiv sau npe Cov ntaub ntawv . Scroll down ces nyem rau ntawm qhov Tshem cov duplicates kev xaiv.
4. Lub thawv pop-up yuav tshwm sim, nug cov kab twg los txheeb xyuas. Xaiv cov kev xaiv raws li koj xav tau thiab ces nias rau ntawm qhov Tshem cov duplicates khawm.
5. Tag nrho cov ntaub ntawv sib tshooj yuav raug tshem tawm, thiab cov khoom tshwj xeeb yuav nyob twj ywm. Google Sheets yuav hais kom koj nrog rau qhov tus naj npawb ntawm cov ntaub ntawv duplicate uas raug tshem tawm .
6. Nyob rau hauv peb rooj plaub, tsuas yog ib tug duplicate nkag tau raug tshem tawm (Ajit). Koj tuaj yeem pom tau tias Google Sheets tau tshem tawm qhov sib npaug (saib rau lub screenshot hauv qab no).
Txoj Kev 2: Tshem tawm Duplicates nrog Formulas
Formula 1: UNIQUE
Google Sheets muaj cov qauv npe hu ua UNIQUE uas khaws cov ntaub ntawv tshwj xeeb thiab yuav tshem tawm txhua qhov kev nkag nkag los ntawm koj daim ntawv teev npe.
Piv txwv li: = UNIQUE(A2:B7)
1. Qhov no yuav txheeb xyuas cov khoom sib npaug hauv cov Cov kab mob tshwj xeeb (A2: B7) .
ob. Nyem rau ntawm txhua lub xov tooj khoob ntawm koj daim ntawv nthuav qhia thiab sau cov qauv saum toj no. Google Sheets yuav qhia txog qhov ntau ntawm cov hlwb uas koj tau teev tseg.
3. Google Sheets yuav sau cov ntaub ntawv tshwj xeeb uas koj tau ntaus cov qauv. Tom qab ntawd koj tuaj yeem hloov cov ntaub ntawv qub nrog cov ntaub ntawv tshwj xeeb.
Formula 2: COUNTIF
Koj tuaj yeem siv cov qauv no los qhia txog txhua qhov sib npaug ntawm koj daim ntawv tshaj tawm.
1. Piv txwv li: Xav txog cov screenshot hauv qab no uas muaj ib qho kev nkag nkag.
2. Nyob rau hauv lub screenshot saum toj no, ntawm tes C2, cia peb nkag mus rau cov mis raws li, =COUNTIF(A:A2,A2)>1
3. Tam sim no, ib zaug nias tus yuam sij Enter, nws yuav qhia qhov tshwm sim FALSE.
4. Txav tus nas pointer thiab muab tso rau saum lub me me square nyob rau hauv qab feem ntawm lub cell xaiv. Tam sim no koj yuav pom ib tug ntxiv cim es tsis txhob ntawm koj tus nas cursor. Nyem thiab tuav ntawm lub npov ntawd, thiab tom qab ntawd rub nws mus rau ntawm lub xov tooj ntawm tes uas koj xav pom cov ntawv nkag. Google nplooj ntawv yuav cia li luam cov qauv rau cov hlwb uas tseem tshuav .
5. Google Sheet yuav cia li ntxiv TIAS nyob rau hauv pem hauv ntej ntawm duplicate nkag.
Nco tseg : Hauv qhov xwm txheej no, peb tau teev tias yog> 1 (ntau dua 1). Yog li, qhov xwm txheej no yuav tshwm sim TIAS nyob rau hauv qhov chaw uas muaj kev nkag tau ntau tshaj ib zaug. Hauv txhua qhov chaw, qhov tshwm sim yog FALSE.
Txoj Kev 3: Tshem tawm cov ntawv nkag nrog qhov xwm txheej formatting
Koj tuaj yeem siv cov kev cai formatting kom tshem tawm cov ntaub ntawv duplicate los ntawm Google Sheets.
1. Ua ntej, xaiv cov ntaub ntawv teev uas koj xav ua raws li kev cai formatting. Tom qab ntawd, los ntawm cov ntawv qhia zaub mov xaiv Hom ntawv thiab scroll down ces xaiv Kev cai formatting.
2. Nyem rau ntawm qhov Format cells yog… drop-down box, thiab xaiv lub Custom Formula kev xaiv.
3. Sau cov qauv raws li =COUNTIF(A:A2,A2)>1
Nco tseg: Koj yuav tsum hloov cov kab ntawv & kab ntawv raws li koj daim ntawv Google.
4. Cov qauv no yuav lim cov ntaub ntawv los ntawm kab A.
5. Nyem rau ntawm qhov Ua tiav khawm. Yog tias kab A muaj ib qho duplicate cov ntaub ntawv , Google Sheets yuav qhia txog qhov rov ua dua (cov ntawv theej).
6. Tam sim no koj tau yooj yim tshem tawm cov duplicate cov ntaub ntawv.
Txoj Kev 4: Tshem Cov Ntaub Ntawv Duplicate nrog Pivot Table
Raws li cov lus pivot yog ceev-rau-siv thiab yoog raws, koj tuaj yeem siv nws los nrhiav & tshem tawm cov ntaub ntawv sib npaug ntawm koj daim ntawv Google.
Ua ntej, koj yuav tau qhia cov ntaub ntawv hauv Google Sheet. Tom ntej no, tsim ib lub rooj pivot thiab rov hais dua koj cov ntaub ntawv. Txhawm rau tsim ib lub rooj pivot nrog koj cov ntaub ntawv, mus rau qhov Cov ntaub ntawv nyob rau hauv Google Sheet zaub mov thiab nyem rau ntawm Pivot rooj kev xaiv. Koj yuav raug ceeb toom nrog lub thawv nug seb puas yuav tsim lub rooj pivot hauv daim ntawv uas twb muaj lawm lossis ib daim ntawv tshiab. Xaiv ib qho kev xaiv tsim nyog thiab ua mus.
Koj lub rooj pivot yuav raug tsim. Los ntawm lub vaj huam sib luag ntawm sab xis, xaiv qhov Ntxiv khawm nyob ze Kab kom ntxiv cov kab ntsig. Nyob ze ntawm qhov tseem ceeb, xaiv Ntxiv ib kem los kuaj xyuas qhov sib npaug ntawm qhov muaj nuj nqis. Koj lub rooj pivot yuav teev cov txiaj ntsig nrog lawv cov suav (piv txwv li tus naj npawb ntawm cov nqi tshwm sim hauv koj daim ntawv). Koj tuaj yeem siv qhov no los kuaj xyuas qhov sib npaug ntawm cov ntawv nkag hauv Google Sheet. Yog tias suav ntau dua ib qho, qhov ntawd txhais tau hais tias qhov nkag tau rov qab ntau dua ib zaug hauv koj daim ntawv teev npe.
Txoj Kev 5: Siv Apps Script
Lwm txoj hauv kev zoo los tshem tawm duplicated los ntawm koj cov ntaub ntawv yog los ntawm kev siv Apps Script. Muab hauv qab no yog cov apps-ntawv kom tshem tawm cov ntawv nkag los ntawm koj daim ntawv nthuav qhia:
|_+_|Txoj Kev 6: Siv Add-on kom tshem tawm cov duplicates hauv Google Sheets
Siv ib qho add-on los tshem tawm cov ntawv sau sib npaug ntawm koj daim ntawv nthuav qhia tuaj yeem muaj txiaj ntsig. Ob peb qhov kev txuas ntxiv no dhau los ua pab tau. Ib qho kev pab cuam add-on yog qhov ntxiv los ntawm Abblebits npe Tshem cov Duplicates .
1. Qhib Google Sheets, tom qab ntawd los ntawm Ntxiv-ons menu nias rau ntawm Tau txais add-ons kev xaiv.
2. Xaiv qhov Tua tawm icon (highlighted nyob rau hauv lub screenshot) rau tso lub G-Suite Marketplace .
3. Tam sim no nrhiav tus Ntxiv-on koj xav tau thiab nruab nws.
4. Mus dhau qhov kev piav qhia ntawm qhov ntxiv yog tias koj xav tau thiab tom qab ntawd nyem rau ntawm Install kev xaiv.
Txais qhov tsim nyog tso cai rau nruab qhov add-on. Tej zaum koj yuav tau kos npe nrog koj tus lej Google account. Tom qab koj tau teeb tsa lub add-on, koj tuaj yeem yooj yim tshem tawm duplicates ntawm Google Sheets.
Pom zoo:
- Yuav Ua Li Cas Tshem Tawm Ib Ntu Ntug Hauv Microsoft Word
- 5 Txoj hauv kev los ntxig lub cim Square hauv paus hauv Lo Lus
- Yuav Ua Li Cas Ceev Cov Ntawv Sau hauv Google Sheets?
Peb vam tias cov ntaub ntawv no yuav pab tau thiab koj tuaj yeem ua tau yooj yim tshem tawm duplicate nkag los ntawm Google Sheets. Yog tias koj muaj lus nug lossis lus nug hauv koj lub siab, siv cov lus hais los nug lawv.
Elon Decker Elon yog tus kws sau ntawv thev naus laus zis ntawm Cyber S. Nws tau sau cov lus qhia yuav ua li cas txog 6 xyoo tam sim no thiab tau hais txog ntau yam. Nws nyiam hais txog cov ncauj lus hais txog Windows, Android, thiab cov lus qhia tseeb thiab cov lus qhia.