Spreadsheet hachisi chinhu kunze kwegwaro rinoronga data muchimiro chemitsara nemakoramu. Maspreadsheets anoshandiswa nechero bhizinesi sangano kuchengetedza marekodhi edata uye kuita mashandiro pane iyo data. Kunyangwe zvikoro nemakoreji zvinoshandisa spreadsheet software kuchengetedza dhatabhesi yavo. Kana zvasvika kune spreadsheet software, Microsoft Excel uye Google mapepa ndiyo software yepamusoro-soro inoshandiswa nevanhu vakawanda. Mazuva ano, vashandisi vakawanda vanosarudza Google Sheets pamusoro peMicrosoft Excel sezvo ichichengeta maSpreadsheets paCloud Storage yavo, kureva Google Drive iyo inogona kuwanikwa kubva chero nzvimbo. Chinodiwa chete ndechekuti komputa yako inofanirwa kunge yakabatana neInternet. Chimwe chinhu chikuru nezveGoogle Sheets ndechekuti unogona kuishandisa kubva pabrowser yako pahwindo paPC yako.
Kana zvasvika pakuchengetedza zvinyorwa zve data, imwe yenyaya dzakajairika dzinosangana nevashandisi vazhinji ndezvekudzokororwa kana kudhindwa zvinyorwa. Semuenzaniso, fungidzira uine ruzivo rwevanhu vakaunganidzwa kubva muongororo. Paunenge uchivanyora uchishandisa yako spreadsheet software seGoogle Sheets, pane mukana wekudzokorora marekodhi. Kureva kuti, munhu mumwechete anogona kunge akazadza ongororo kanopfuura kamwe, uye saka Google Sheets yaizonyora yekupinda kaviri. Mapindiro akadai ekunyora anonyanya kunetsa kana zvasvika kumabhizinesi. Fungidzira kana mari yekutengeserana yakapinda muzvinyorwa kanopfuura kamwe chete. Kana iwe ukaverenga iyo yakazara mari neiyo data, ingave nyaya. Kuti udzivise mamiriro akadai, munhu anofanirwa kuve nechokwadi chekuti hapana marekodhi akadhindwa muspredishiti. Nzira yekuita sei izvi? Zvakanaka, mugwaro iri, iwe uchakurukura nzira 6 dzakasiyana dzekubvisa zvakapetwa muGoogle Sheets. Huyai, pasina imwe sumo, ngatitarisei mumusoro wenyaya.
Zviri mukati[ hide ]
- Maitiro ekubvisa Duplicates muGoogle Sheets?
- Method 1: Kushandisa iyo Bvisa Duplicates Sarudzo
- Method 2: Bvisa Duplicates neFormulas
- Method 3: Bvisa Duplicate Entries ane Conditional Formatting
- Nzira 4: Bvisa Duplicate Records nePivot Table
- Nzira 5: Kushandisa Apps Script
- Nzira 6: Shandisa Add-on kuti Ubvise Duplicates muGoogle Sheets
Maitiro ekubvisa Duplicates muGoogle Sheets?
Duplicate marekodhi anonetsa chaizvo panyaya yekuchengeta data rekodhi. Asi haufanirwe kunetsekana sezvo uchigona kubvisa zviri nyore zvinyorwa kubva kuGoogle Sheets spreadsheet. Ngatione dzimwe nzira dzaungabvisa nadzo zvakapetwa muGoogle Sheets.
Method 1: Kushandisa iyo Bvisa Duplicates Sarudzo
Google Sheets ine yakavakirwa-mukati sarudzo yekubvisa manyorerwo anodzokororwa (duplicate entries). Kuti ushandise sarudzo iyoyo, tevera mufananidzo uri pasi apa.
1. Semuenzaniso, tarisa izvi (ona skrini pazasi). Pano unogona kuona kuti rekodhi Ajit inopinzwa kaviri. Iri rekodhi rekodhi.
2. Kubvisa zvakapetwa kaviri, sarudza kana simbisa mitsetse nemakoramu.
3. Zvino tinya pane menyu sarudzo yakanyorwa Data . Skroka pasi wobva wadzvanya pa Bvisa zvakapetwa sarudzo.
4. A pop-up box ichauya, ichibvunza kuti ndeapi makoramu ekuongorora. Sarudza sarudzo maererano nezvaunoda uye wobva wadzvanya pa Bvisa zvakapetwa bhatani.
5. Marekodhi ese akadhindwa aizobviswa, uye zvinhu zvakasiyana zvaizosara. Google Sheets inokukurudzira kuti uite nhamba yezvinyorwa zvekare zvakabviswa .
6. Muchiitiko chedu, chinyorwa chimwe chete chechipiri chakabviswa (Ajit). Iwe unogona kuona kuti Google Sheets yakabvisa iyo yakapetwa yekupinda (tarisa kune iyo skrini inotevera).
Method 2: Bvisa Duplicates neFormulas
Formula 1: UNIQUE
Google Sheets ine fomula inonzi UNIQUE inochengeta marekodhi akasiyana uye inobvisa zvese zvakapetwa kaviri kubva paspredishiti rako.
Semuyenzaniso: =CHAKASIYANA(A2:B7)
1. Izvi zvaizotarisa kune zvakapetwa kaviri mu dzakatarwa masero (A2:B7) .
piri. Dzvanya pane chero sero isina chinhu pane yako spreadsheet uye isa fomula iri pamusoro. Google Sheets yaizoratidza huwandu hwemasero aunotsanangura.
3. Google Sheets inonyora marekodhi akasarudzika kwawakataipa fomula. Iwe unogona ipapo kutsiva iyo yekare data neakasarudzika marekodhi.
Formula 2: COUNTIF
Unogona kushandisa fomula iyi kuratidza zvese zvakapetwa kaviri muspredishiti rako.
1. Semuyenzaniso: Funga zvinotevera screenshot ine imwe duplicate entry.
2. Mumufananidzo uri pamusoro, pasero C2, ngatiise fomula se, =COUNTIF(A:A2, A2)>1
3. Zvino, kana Enter kiyi ikadzvanywa, icharatidza mhedzisiro se NHEMA.
4. Fambisa chinongedzo chembeva wochiisa pamusoro pe diki square pazasi chikamu chesero rakasarudzwa. Iye zvino iwe uchaona chiratidzo chekuwedzera pane yako mbeva cursor. Dzvanya uye ubate pabhokisi iro, wobva warikwevera kumusoro kuchitokisi kwaunoda kutsvaga zvakapetwa. Google mapepa aizodaro kopira otomatiki fomula kune asara maseru .
5. Google Sheet inongowedzera TRUE pamberi peduplicate yekupinda.
CHERECHEDZA : Mumamiriro ezvinhu aya, takatsanangura se> 1 (yakakura kupfuura 1). Saka, mamiriro aya aizoguma TRUE munzvimbo dzinowanikwa kupinda kunowanikwa kanopfuura kamwe chete. Mune dzimwe nzvimbo dzose, mhedzisiro yacho NHEMA.
Method 3: Bvisa Duplicate Entries ane Conditional Formatting
Iwe unogona zvakare kushandisa yezvimiro fomati kubvisa zvakapetwa marekodhi kubva kuGoogle Sheets.
1. Kutanga, sarudza iyo data seti yaungada kuita ine mamiriro ekugadzirisa. Zvadaro, kubva paMenu sarudza Format uye wobva wadzvanya pasi wozosarudza Conditional formatting.
2. Dzvanya pa Fomati masero kana... bhokisi rekudonhedza pasi, uye sarudza iyo Custom Formula sarudzo.
3. Isa fomura se =COUNTIF(A:A2, A2)>1
Cherechedza: Iwe unofanirwa kushandura mutsara & column data zvichienderana neGoogle Sheet yako.
4. Iyi fomula yaizosefa marekodhi kubva muchikamu A.
5. Dzvanya pa Zvaita bhatani. Kana chikamu A chine chero duplicate zvinyorwa , Google Sheets icharatidza izvo zvinodzokororwa zvinyorwa (zvakapetwa).
6. Iye zvino unogona kudzima zviri nyore zvinyorwa izvi zvakapetwa.
Nzira 4: Bvisa Duplicate Records nePivot Table
Sezvo matafura epivot ari kukurumidza-kushandisa uye anochinjika, unogona kuishandisa kuwana & kubvisa zvakapetwa marekodhi kubva kuGoogle Sheet.
Kutanga, iwe uchafanirwa kuratidza iyo data muGoogle Sheet. Tevere, gadzira tafura yepivot uye simbisazve data rako. Kuti ugadzire tafura yepivot ine dataset yako, enda ku Data pasi peGoogle Sheet menyu uye tinya pa Pivot table sarudzo. Iwe unozokurudzirwa nebhokisi uchibvunza kuti wogadzira tafura yepivot mupepa riripo here kana kuti shiti idzva. Sarudza sarudzo yakakodzera uye enderera.
Tafura yako yepivot ichagadzirwa. Kubva papaneru kurudyi, sarudza iyo Wedzera bhatani riri pedyo neRow kuti uwedzere mitsara inowirirana. Pedyo nema values, sarudza ku Add a column kuti utarise kudzokororwa kwe values. Tafura yako yepivot yaizonyora kukosha nekuverenga kwavo (kureva nhamba yenguva iyo kukosha kunoitika mubepa rako). Unogona kushandisa izvi kutarisa kudzokorora kwezvinyorwa muGoogle Sheet. Kana kuverenga kuchipfuura imwe, zvinoreva kuti kupinda kunodzokororwa kanopfuura kamwe muspredishiti rako.
Nzira 5: Kushandisa Apps Script
Imwe nzira huru yekubvisa yakadzokororwa kubva kugwaro rako kushandisa iyo Apps Script. Inopiwa pazasi ndeye-apps-script yekubvisa zvakapetwa zvinyorwa kubva paspredishiti rako:
|_+_|Nzira 6: Shandisa Add-on kuti Ubvise Duplicates muGoogle Sheets
Kushandisa add-on kubvisa zvakapetwa kaviri kubva paspredishiti yako kunogona kubatsira. Kuwedzera kwakawanda kwakadaro kunobatsira. Imwe yakadai yekuwedzera-purogiramu ndeye yekuwedzera ne Ablebits zita Bvisa Maduplicates .
1. Vhura Google Sheets, wobva wabva Wedzera-ons menyu tinya pa Wana ma-add-ons sarudzo.
2. Sarudza iyo Launch icon (yakasimudzwa muscreenshot) kuvhura iyo G-Suite Musika .
3. Zvino tsvaga Wedzera-on unoda woiisa.
4. Enda kuburikidza netsanangudzo ye-add-on kana uchida uye ipapo tinya pane Install sarudzo.
Gamuchira mvumo inodiwa yekuisa iyo yekuwedzera. Unogona kusaina neakaundi yako yeGoogle account. Mushure mekunge waisa iyo yekuwedzera, unogona kubvisa zviri nyore zvakapetwa kubva kuGoogle Sheets.
Zvinokurudzirwa:
- Maitiro ekudzima Chikamu Kupwanya muMicrosoft Word
- 5 Nzira dzekuisa Square Root Symbol muIzwi
- Maitiro eKukurumidza Kupeta Chinyorwa muGoogle Sheets?
Tinovimba kuti ruzivo urwu rwakabatsira uye makakwanisa bvisa zviri nyore zvakapetwa kubva kuGoogle Sheets. Kana uine chero mazano kana mibvunzo mupfungwa dzako, shandisa chikamu chekutaura kuvabvunza.
Elon DeckerElon munyori wehunyanzvi paCyber S. Anga achinyora maitirwo-magwara kweanenge makore matanhatu zvino uye akafukidza akawanda misoro. Anoda kuvhara misoro ine chekuita neWindows, Android, uye azvino matipi uye matipi.