USU  ››  Zvirongwa zvebhizimusi otomatiki  ››  Chirongwa chekiriniki  ››  Mirayiridzo yechirongwa chekurapa  ›› 

Tsvaga zvakapetwa muchikamu

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Apa takatarisa nzira yekuvaka mwero wezvakanakisa kana zvakaipa.

Unoda kutsvaga zvakapetwa mukoromo? Iye zvino iwe unogona kudzidza nzira yekukurumidza kuwana zvakapetwa kana akasiyana hunhu muchirongwa.

Unique values

Ngativhure module "Visits" .

Iye zvino tinosarudza otomatiki yekutanga "varwere" uyo akauya kuzoona chiremba kekutanga. Kuti tiite izvi, tinoenda kumurairo watinotoziva "Conditional Formatting" .

Ndapota verenga kuti nei usingazokwanisi kuverenga mirairo yakafanana uye kushanda pahwindo rinoonekwa.

Kana uchine mitemo yekufomatidza kubva kumienzaniso yapfuura, bvisa yese.

Wobva wawedzera mutemo mutsva wefomati yedata uchishandisa bhatani re' Nyowani '.

Tevere, sarudza iyo ' Format yakasarudzika kukosha chete ' kukosha kubva pane iyo rondedzero. Wobva wadzvanya bhatani re' Format ' uye ita kuti font ishinge.

Isa mafomati aya kuchikamu che' Patient '.

Nekuda kweizvozvo, tichaona varwere vekutanga. Aya ndiwo achave marekodhi enguva yakasarudzwa, ayo anoratidzwa mune rondedzero kamwe chete.

Duplicate kuratidza

Nenzira imwecheteyo, iwe unogona kuwana zvese zvakapetwa. Ngatiratidzei mune rumwe ruvara mazita evarwere vanoonekwa mune rondedzero yekushanya kanopfuura kamwe. Kuti uite izvi, wedzera mamiriro matsva ekugadzirisa.

Mamiriro ese ari maviri ekufomatidza anofanirwa kuiswa kune imwechete munda.

Iye zvino mune runyorwa rwekushanya, varwere vedu venguva dzose vanoratidzirwa mune inonakidza ruvara rwegirinhi.

Tsvaga kana maduplicate achibvumidzwa muzvikamu zvakakosha.

Ona pazasi mamwe misoro inobatsira:

• Maduplicate anogona kuiswa here?
• Rongedza tsika
• Simbisa Zvinhu Zvinokosha
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana