Ndichiri kushanda pa Google Mapepa Unogona kusangana nemashizha mahombe uko iwe unofanirwa kubata nezvakawanda zvakapetwa zvinyorwa.
Isu tinonzwisisa kuoma kwekubata zvakapetwa uye kuti zvingave zvakaoma sei kana ukasimbisa uye kubvisa zvakanyorwa chimwe nechimwe.
Nekudaro, nerubatsiro Mamiriro Ekugadzirisa Kumaka nekubvisa zvakapetwa kunova nyore kwazvo.
Ipo mafomati ane mamiriro akaita kuti zvive nyore kwazvo kusiyanisa zvakapetwa mu Google Mapepa.
Tevedzera gwaro iri apo isu tinokuudza mawaniro aungaita uye kubvisa zvakapetwa zvinyorwa muGoogle Sheets.
Zvese zvinotora mashoma mashoma kuti ubvise zvakapetwa muGoogle Sheets uye ngatizivanei.
Google Sheets: Maitiro ekumisikidza zvakapetwa mukoramu imwe
usati waziva Maitiro ekubvisa zvakapetwa zvinyorwa kubva maspredishiti Google Ngatidzidzei kusiyanisa zvakapetwa mukoramu imwe chete. Tevedza nhanho idzi.
- Vhura iyo spreadsheet muGoogle Sheets uye sarudza ikholamu.
- Semuenzaniso, sarudza Chikamu A > Coordinate > Coordinate Mupurisa .
- Pasi Pemitemo yekuumbwa, vhura iyo inodonhedza menyu uye sarudza Iyo tsika fomula ndeye .
- Pinda kukosha kweiyo tsika fomula, = kuverenga (A1: A, A1)> 1 .
- Pasi pemitemo yeMafomati, unogona kuwana Mafomati Emafomati, ayo anotendera iwe kuti upe imwe kara kune akasiyana akaoneswa. Kuti uite izvi, tinya pane iyo icon Zadza ruvara Uye sarudza waunofarira mumvuri.
- Paunenge wapedza, pinda Done أو Yakanga yapedzwa Kusimbisa zvakapetwa mukoramu imwe chete.
- Saizvozvo, kana iwe uchifanira kuita izvi kune ikholamu C, fomula yacho inova, = countif (C1: C, C1)> 1 uye kuda Saka zvekare kune mamwe makoramu.
Kunze kwezvo, pane nzira yekutsvaga zvakapetwa pakati pemakoramu zvakare. Kuti udzidze, tevera nhanho idzi.
- Ngatiti iwe unoda kuratidza zvakapetwa pakati pemasero C5 kusvika C14.
- Mune ino kesi, enda ku Coordinate uye sarudza mamiriro ekumisikidza .
- Pasi Nyorera pachiyero, pinda data renji, C5:C14 .
- Tevere, pasi peMitemo yekuFomati, vhura iyo inodonhedza menyu uye sarudza Iyo tsika fomula ndeye .
- Pinda kukosha kweiyo tsika fomula, = kuverenga (C5: C, C5)> 1 .
- Kana zvichidikanwa, govera rakasiyana ruvara kune akasimbiswa makopi nekutevera apfuura matanho. Paunenge wapedza, pinda Yakanga yapedzwa .
- Kana zvichidikanwa, govera rakasiyana ruvara kune akasimbiswa makopi nekutevera apfuura matanho. Paunenge wapedza, pinda Yakanga yapedzwa .
Google Sheets: Maitiro ekuona zvakapetwa pamakoramu akawanda
Ingoitika kana iwe uchida kumaka zvakapetwa pamakoramu akawanda nemitsara, tevera matanho aya.
- Vhura iyo spreadsheet muGoogle Sheets uye sarudza akawanda makoramu.
- Semuenzaniso, sarudza makoramu B kusvika E> tinya urongwa > Dzvanya mamiriro ekumisikidza .
- Pasi Pemitemo yekuumbwa, vhura iyo inodonhedza menyu uye sarudza Iyo tsika fomula ndeye .
- Pinda kukosha kweiyo tsika fomula, = kuverenga (B1: E, B1)> 1 .
- Kana zvichidikanwa, govera rakasiyana ruvara kune akasimbiswa makopi nekutevera apfuura matanho. Paunenge wapedza, pinda Yakanga yapedzwa .
- Saizvozvo, kana iwe uchida kudoma zvinoitika zvekoramu M kusvika P, unotsiva B1 neM1 uye E na P. Fomula nyowani inova, = kuverenga (M1: P, M1)> 1 .
- Pamusoro pezvo, kana iwe uchida kumaka zvinoitika zvemakoramu ese kubva A kusvika Z, ingo dzokorora matanho apfuura uye isa kukosha kweiyo tsika fomula, = kuverenga (A1: Z, A1)> 1 .
Google Sheets: Bvisa zvakapetwa kubva paspredishiti rako
Mushure mekupedza kuburitsa zvakapetwa zvakapetwa muspredishiti, rinotevera danho rekudzima. Tevedza nhanho idzi.
- Sarudza iyo ikholamu yaunoda kubvisa zvakapetwa.
- Dzvanya ب الب > bvisa zvakapetwa .
- Iwe zvino uchaona popup. isa mucherechedzo Mubhokisi riri padhuze nedata rine musoro ikozvino> tinya duplicate bvisa > Dzvanya Yakanga yapedzwa .
- Iwe unogona zvakare kudzokorora nhanho dzemamwe makoramu.
Aya ndiwo maitiro aunomaka uye kubvisa zvakapetwa mu Google Mapepa.
