Yuav Paub
- Remove Duplicates: Xaiv cov xov tooj ntawm tes / kab los tshawb > Data > Data Cleanup > Tshem tawm Duplicates.
- UNIQUE muaj nuj nqi: Xaiv thawj lub xov tooj hauv kab rau cov khoom xa rov qab > Insert > Function > Filter > Unique.
- Tom ntej: Xaiv qhov kev tshawb nrhiav ntau yam > nias Enter > Cov ntawv yuav tsim kab tshiab / rooj ntawm cov khoom tshwj xeeb.
Kab lus no piav qhia yuav ua li cas thiaj nrhiav tau thiab tshem tawm cov khoom sib xws hauv Google Cov Ntawv uas siv cov haujlwm tsim los lossis cov neeg thib peb add-ons.
Nrhiav Duplicates hauv Google Sheets Siv Cov Cuab Yeej Tshem Tawm
Google Sheets suav nrog cov cuab yeej built-in uas yuav tshawb cov ntawv raws li cov qauv koj muab.
Thaum koj siv lub cuab yeej tshem tawm Duplicates, nws yuav cia li tshem tawm cov duplicates nws pom. Koj yuav tsis muaj sijhawm los saib lawv ua ntej. Yog tias koj xav tshuaj xyuas lawv ua ntej Google Sheets tshem tawm lawv, tej zaum koj yuav xav sim ua kom pom qhov sib npaug hauv Google Sheets xwb.
- Qhib daim ntawv nthuav dav uas koj xav nrhiav thiab tshem tawm cov ntaub ntawv sib npaug.
-
Xaiv cov ntaub ntawv ntau yam uas koj xav tshem tawm duplicates.
Cells nrog cov txiaj ntsig zoo ib yam, tab sis sib txawv formatting, qauv, lossis cov ntawv sau raug suav tias yog duplicate.
-
Xaiv Data > Data Cleanup > Tshem tawm Duplicates. Lub Remove Duplicates dialog box yuav qhib qhia cov naj npawb ntawm kab thiab kab xaiv.
Image -
Xaiv tus Cov ntaub ntawv muaj kab ntawv kab lus checkbox yog tias koj daim ntawv nthuav qhia suav nrog kab hauv kab los tiv thaiv kab no los ntawm kev cuam tshuam.
Image -
Xaiv kab koj xav tau lub cuab yeej los txheeb xyuas los ntawm kev xaiv cov thawv ntawv txheeb. Txhawm rau txheeb xyuas txhua kab, xaiv lub Xaiv Txhuacheckbox.
Yog tias koj xaiv ib lub xovtooj ntawm ib qho, qhov sib npaug yuav raug tshem tawm rau tag nrho ntau yam.
Image -
Xaiv Tshem tawm Duplicates. Cov cuab yeej yuav tshuaj xyuas cov ntaub ntawv, thiab ib lub thawv yuav tshwm sim qhia tias muaj pes tsawg kab duplicate Google Sheets pom thiab tshem tawm.
Image
Nrhiav duplicates hauv Google Sheets Siv lub UNIQUE Function
Lub luag haujlwm UNIQUE hauv Google Cov Ntawv xa rov qab cov kab tshwj xeeb los ntawm qhov muab ntau yam, pov tseg qhov sib npaug. UNIQUE muaj nuj nqi xa rov qab kab hauv qhov kev txiav txim lawv thawj zaug tshwm sim hauv qhov chaw. Siv txoj kev no, koj tuaj yeem saib thiab sib piv ob pawg ntawm cov ntaub ntawv ua ntej tshem cov qub duplicates.
Ua kom cov lej muaj txiaj ntsig tau tsim tib yam, xws li feem pua lossis cov txiaj ntsig txiaj.
- Xaiv thawj lub xovtooj ntawm kab ntawv uas koj xav kom cov kab tshwj xeeb rov qab.
-
Xaiv Insert > Function.
Image -
Xaiv Filter> Unique.
Image -
Tau los yog xaiv qhov ntau yam koj xav siv los ua qhov kev sib cav rau txoj haujlwm thiab nias Enter.
Image -
Google Sheets yuav tsim ib kab tshiab lossis lub rooj nrog cov kab tshwj xeeb suav nrog.
Yog tias xa rov qab kab zoo li suav nrog cov sib npaug, nrhiav cov hlwb uas muaj cov ntawv zais lossis lwm qhov sib txawv, xws li qhov chaw tom qab.
Nrhiav thiab tshem tawm qhov sib npaug hauv Google Cov Ntawv Siv Ntxiv-on
Add-ons yog cov cuab yeej tsim los ntawm cov neeg tsim tawm thib peb uas txhim kho lossis ua kom yooj yim rau koj qhov kev paub siv Google Sheets. Add-ons muaj nyob rau hauv uas yuav pom thiab tshem tawm cov duplicates ntawm koj daim ntawv nthuav qhia hauv Google Sheets.
Thaum tsis muaj ob qhov ntxiv-ons zoo ib yam, ntau yam suav nrog cov yam ntxwv zoo sib xws. Kawm paub yuav ua li cas nrhiav cov add-ons uas nrhiav thiab tshem tawm cov duplicates hauv Google Sheets thiab yuav ua li cas txiav txim siab seb qhov twg zoo tshaj plaws rau koj cov kev xav tau.
- mus rau Google Sheets.
-
Xaiv Add-ons > Tau Add-ons. Lub qhov rais Add-ons yuav qhib nrog ob peb cov cuab yeej pom zoo.
Image -
Type " remove duplicates" rau hauv Tshawb nrhiav add-ons teb thiab nias Enter. Ib daim ntawv teev cov muaj peev xwm add-ons txuam nrog koj qhov kev tshawb fawb yuav tshwm sim.
Image -
Xaiv ib qho ntxiv uas koj xav kawm ntxiv txog qhib nplooj ntawv piav qhia. Scroll cia los nyeem cov kev tshuaj xyuas lossis scroll sab xis thiab sab laug kom pom cov screenshots thiab cov yeeb yaj kiab uas nthuav tawm cov add-on hauv kev nqis tes ua.
Image -
Xaiv Ntxiv.
Image Tus khawm Ntxiv tej zaum yuav muaj nqe lossis lo lus " Free" rau ntawm nws.
- Xaiv lossis kos npe rau hauv koj tus lej Google yog tias tau nug.
-
Xaiv Allow los muab qhov kev thov kev tso cai rau tus ntxiv.
Image - Tau thaum lub add-on raug teeb tsa.
-
Xaiv Add-ons nkag mus thiab siv lub cuab yeej.
Image Xaiv Help hauv cov ntawv qhia ntxiv kom tau txais kev pab siv cov cuab yeej koj tau rub tawm.
