Nzira yekuwana sei duplicate masero mune Excel sheet

Rimwe remabasa echinyakare ekutsvaga zvikanganiso kana kuchenesa faira reExcel nderekutsvaga masero akapetwa.

Pane nzira dzakati wandei dzekutsvaga masero akapetwa, mune ino chinyorwa tichatarisa nzira mbiri dziri nyore dzekuwana nekusimbisa duplicate masero muExcel spreadsheet.

Tsvaga masero akapetwa muExcel

Kuenzanisira mawaniro emasero akadhindwa muExcel, ngatishandisei iri nyore spreadsheet pazasi, ine runyoro rwemazita muchikamu A.

Ngatitangei tiratidze mashandisiro emaitiro ekufomatidza kuratidza masero akapetwa, tobva taratidza kuti sei shandisa basa Countif yeExcel kutsvaga zvakapetwa.

Simbisa masero akadhindwa uchishandisa conditional fomati

Kuti uwane duplicate masero ane conditional fomati, tevera matanho ari pasi apa:

• Sarudza huwandu hwemaseru ekufomatidza.
• Sarudza iyo Conditional Formatting yekudonha-pasi menyu kubva paKumba tebhu kumusoro kweExcel bhuku rako rebasa. Mukati memenyu iyi:
  • Sarudza sarudzo Simbisa mitemo yesero uye, kubva kune yechipiri menyu inoonekwa, sarudza iyo Values ​​sarudzo zvakapetwa… ;

• The “Duplicate values“. Menyu yekudonhedza pasi kuruboshwe kwehwindo rino inofanirwa kuratidza kukosha kwe "Dhikirita" (kunyangwe izvi zvichigona kushandurwa kuratidza chete hunhu hwakasiyana, pane kudzokororwa).

• Dzvanya OK .

Kugadzira maseru A2-A11 emuenzaniso spreadsheet nenzira iyi inoburitsa zvinotevera:

Tsvaga zvakapetwa uchishandisa Countif

Iyi nzira inongoshanda chete kana zviri mukati mesero zvisingasviki 256 mavara pakureba, seExcel mabasa asingakwanisi kubata tambo dzemavara refu.

Kuenzanisira nzira yekushandisa iyo basa Countif Kuti tiwane zvakapetwa muExcel, isu tichashandisa muenzaniso wespredishiti uri pamusoro, une runyoro rwemazita anozadza chikamu A.

Kuti uwane chero zvakapetwa mumazita emazita, isu takabatanidza basa racho Countif muchikamu B chespredishiti, kuratidza nhamba yezviitiko zvezita rega rega. Sezvinoratidzwa muformula bar, basa racho Countif inoshandiswa muchitokisi B2 ndiyo :=COUNTIF( A:A, A2 )

Iri basa rinoverenga nhamba yezvinoitika zvekukosha muchitokisi A2 (zita rekuti "Adam SMITH") mukati mechikamu A chespredishiti.

Kana basa Countif inokopwa kukoromo B yespredishiti, ichaverenga huwandu hwezviitiko zvemazita mumasero A3, A4, nezvimwe.

Unogona kuona kuti basa racho Countif inodzosera kukosha 1 kune mitsetse mizhinji, zvichiratidza kuti pane chiitiko chimwe chete chemazita mumasero A2, A3, nezvimwe. Zvisinei, kana zvasvika kune zita rokuti "John ROTH", (iro riripo mumasero A3 neA8), basa rinodzorera kukosha kwe2, kuratidza kuti pane zviitiko zviviri zvezita iri.

Ercole Palmeri