Duplicate data ndiyo bane yespredishiti mhinduro, kunyanya pachiyero. Tichifunga nezve vhoriyamu uye akasiyana e data apinda nezvikwata, zvinogoneka kuti inodzokorora data mumaturusi akadai Google Sheetsiti inogona kuve yakakosha uye yakakosha, kana inogona kuve kukanganisa kunoshungurudza kubva pachinangwa chekutanga chekuedza kwespredishiti.
Dambudziko rinogona kuitika rinomutsa mubvunzo wakanaka: Unosimbisa sei zvakapetwa muGoogle Sheets?
Takakufukidza iwe nhanho-ne-nhanho yekutarisa maitiro ekusimbisa zvakapetwa muGoogle Sheets, izere nemifananidzo kuti uve nechokwadi chekuti uri munzira chaiyo kana zvasvika pakubvisa-kudzokorora data rako.
Kusimudzira Dhata Yakadzokororwa muGoogle Sheets
Google Sheets ndeye yemahara, yegore-yakavakirwa imwe nzira kune varidzi vespredishiti zvirongwa uye - hazvishamise, sezvo iri Google yatiri kubata nayo - inopa huwandu hwezvinhu zvakanaka kubatsira kugadzirisa kupinda kwedata, fomati, uye kuverenga.
Google Sheets ine zvese zvinozivikanwa mabasa: Faira, Rongedza, Tarisa, Format, Dhata, Zvishandiso, nezvimwe uye inoita kuti zvive nyore kukurumidza kuisa data rako, wedzera. mazano pakuverenga, uye tsvaga hukama hwakakosha. Izvo MaSheets asina, zvakadaro, inzira iri nyore yekuwana nekusimbisa zvakapetwa.
Nepo mamwe maturusi espredishiti, zvakadai seExcel, vane akavakirwa-mukati mafomati maturusi anogona kunongedza zvakapetwa dhata mubepa rako, mhinduro yeGoogle inoda imwe kushanda nesimba.
Nhanho-ne-Nhanho: Maitiro ekusimbisa Zvakadzokororwa muGoogle Sheets (Nemifananidzo)
Saka iwe unoisa sei otomatiki zvakapetwa muGoogle Sheets? Nepo pasina chakavakirwa-mukati chishandiso cheichi chinangwa, unogona kukwidziridza mamwe akavakirwa-mukati mabasa kuratidza yakapetwa data.
Heino nhanho-ne-nhanho gwara:
Danho 1: Vhura spreadsheet yako.
Danho 2: Simbisa iyo data yaunoda kutarisa.
Danho rechitatu: Pasi pe "Format", sarudza "Conditional Formatting."
Nhanho 4: Sarudza "Custom formula ndeye."
Nhanho yechishanu: Isa iyo yakajairika dhizaini yekutarisa formula.
Danho rechitanhatu: Dzvanya "Zvaitwa" kuti uone zvabuda.
Danho 1: Vhura spreadsheet yako.
Kutanga, tungamira kuGoogle Sheets uye wovhura spreadsheet yaunoda kutarisa kuti yadhindwa data.
Danho 2: Simbisa iyo data yaunoda kutarisa.
Tevere, tinya-kuruboshwe uye dhonza chitubu chako pamusoro peiyo data yaunoda kutarisa kuti uiratidze.
Danho rechitatu: Pasi pe "Format", sarudza "Conditional Formatting."
Iye zvino, tungamira ku "Format" mumutsara wemenyu yepamusoro uye sarudza "Conditional Formatting". Unogona kuwana chiziviso chinoti "sero haina chinhu" - kana zvakadaro, tinya pairi, uye iwe unofanirwa kuona izvi:
Nhanho 4: Sarudza "Custom formula ndeye."
Tevere, isu tinofanirwa kugadzira fomula yakajairwa. Pasi pe "Fomati masero kana", sarudza yekudonha-pasi menyu uye skira pasi ku "Custom formula ndeye".
Nhanho yechishanu: Isa iyo yakajairika dhizaini yekutarisa formula.
Kuti titsvage data rakadhindwa, isu tinofanirwa kuisa iyo yakajairika dhizaini yekutarisa formula, iyo kune yedu column yedata inoita seizvi:
=COUNTIF(A:A,A1)>1
Iyi fomula inotsvaga chero tambo yemavara inooneka kanopfuura kamwe mune yedu yakasarudzwa data set, uye nekusarudzika inoisimbisa mune yegirini. Kana uchida rumwe ruvara, tinya pane diki poto yependi icon mubhawa yekufomatidza uye sarudza ruvara rwaunoda.
Danho rechitanhatu: Dzvanya "Zvaitwa" kuti uone zvabuda.
Uye voilà - isu takasimbisa iyo yakapetwa data muGoogle Sheets.
Maitiro ekusimbisa zvakadzokororwa muMitsetse yakawanda uye Columns
Kana iwe uine yakakura data set kuti utarise, zvinogoneka zvakare kuratidza data rakadzokororwa mumakoramu akawanda kana mitsetse.
Izvi zvinotanga nenzira imwechete seyekudzokororwa kwekutarisa maitiro pamusoro - mutsauko chete ndewekuti iwe unoshandura dhata renji kuti ubatanidze maseru ese aunoda kuenzanisa.
Mukuita, izvi zvinoreva kupinda yakawedzera data renji muConditional fomati yemitemo menyu uye neyakajairwa fomati bhokisi. Ngatishandisei muenzaniso uri pamusoro sepokutangira, asi pachinzvimbo chekungotsvaga pachikamu A kuti tiwane zvakapetwa, tichatsvaga mumakoramu matatu: A, B, naC, uye zvakare kuyambuka mitsetse 1-10.
Kana isu tikapinda nemitemo yedu yemafomati, Nyorera kuRange inova A1:C10 uye fomula yedu yetsika inova:
=COUNTIF($A$2:G,Indirect(Kero(Row(),Column(),)))>1
Izvi zvicharatidza zvese zvakapetwa pamakoramu ese matatu uye ese gumi mitsara, zvichiita kuti zvive nyore kuona data doppelgangers:
Kuita Nezvakadzokororwa muMadhodhi muGoogle Sheets
Unogona here kuratidza zvakapetwa muGoogle Sheets? Zvamazvirokwazvo. Nepo maitiro acho achitora simba rakawanda kupfuura mamwe maspredishiti mhinduro, zviri nyore kudzokorora kana wangozviita kamwe kana kaviri, uye kana wanyatsogadzikana nemaitiro unogona kukwira kumusoro kuti uwane zvakapetwa mumitsara, makoramu, uye kunyange zvakawanda. yakakura data seti.