Maitiro ekutsvaga Duplicate Values ​​muExcel Tafura Column

Tafura ine maitiro akafanana idambudziko rakakura kune vazhinji vashandisi veMicrosoft Excel. Ruzivo rwekudzokorora runogona kubviswa uchishandisa zvishandiso zvakavakwa muchirongwa, zvichiunza tafura kune yakasarudzika. Nzira yekuzviita nayo zvakarurama ichakurukurwa munyaya ino.

Method 1 Maitiro ekutarisa tafura kune zvakapetwa uye woabvisa uchishandisa iyo Conditional Formatting chishandiso

Kuti ruzivo rumwe chete rusadzokororwe kakawanda, runofanira kuwanikwa uye kubviswa kubva patafura yetafura, ichisiya sarudzo imwe chete. Kuti uite izvi, unofanirwa kuita zvinotevera:

1. Shandisa bhatani rekuruboshwe rembeva kuti usarudze huwandu hwemaseru aunoda kutarisa kuti uwane rumwe ruzivo. Kana zvichidikanwa, unogona kusarudza tafura yose.
2. Pamusoro pechidzitiro, tinya pane "Kumba" tebhu. Zvino, pasi peturusi, nzvimbo ine mabasa echikamu chino inofanira kuratidzwa.
3. Muchikamu che "Styles", tinya-kuruboshwe pakanzi "Conditional Formatting" kuti uone zvingaita basa iri.
4. Mune menyu yemukati inooneka, tsvaga mutsara "Gadzira mutemo ..." uye tinya pairi neLMB.

5. Mune inotevera menyu, muchikamu che "Sarudza rudzi rwekutonga", iwe uchafanirwa kusarudza mutsara "Shandisa fomula kuona maseru akarongwa."
6. Zvino, mumutsara wekuisa pazasi pechikamu ichi, iwe unofanirwa kuisa nemaoko fomula kubva kukhibhodi “=COUNTIF($B$2:$B$9; B2)>1”. Mabhii ari mumaparenthesi anoratidza huwandu hwemasero achaitwa mafomati nekutsvaga maduplicate. Mumabhuraketi, zvinodikanwa kuti urondedzere rakati siyana rezvimiro zvetafura uye kusungirira zviratidzo zvemadhora pamaseru kuitira kuti fomula "irege "kubuda kunze" panguva yekugadzira.

7. Kana uchida, mune "Gadzira mutemo wekufometa", mushandisi anogona kudzvanya bhatani re "Format" kuitira kuti ataure ruvara ruchashandiswa kuratidza zvakapetwa pahwindo rinotevera. Izvi zvakaringana, nekuti zvakadzokororwa tsika dzinobva dzabata ziso.

Teerera! Unogona kuwana zvakapetwa muExcel spreadsheet nemaoko, neziso, nekutarisa sero rega rega. Nekudaro, izvi zvinotora mushandisi nguva yakawanda, kunyanya kana tafura hombe iri kuongororwa.

Method 2: Tsvaga uye bvisa zvakapetwa maitiro uchishandisa Bvisa Duplicates bhatani

Microsoft Office Excel ine chinhu chakakosha chinokutendera kuti ubvise maseru nekukasira ruzivo kubva patafura. Iyi sarudzo inoshandiswa sezvinotevera:

1. Saizvozvo, simbisa tafura kana kuti yakati wandei masero mune Excel worksheet.
2. Mune runyorwa rwezvishandiso pamusoro peiyo huru menyu yechirongwa, tinya paizwi rekuti "Data" kamwe nebhatani rekuruboshwe.
3. Muchikamu che "Kushanda nedata", tinya pakanzi "Delete duplicates".

4. Mumenu iyo inofanirwa kuoneka mushure mekuita manipulations ari pamusoro, tarisa bhokisi riri padivi pemutsara "My data" rine misoro. Muchikamu che "Columns", mazita emakoroni ose eplate achanyorwa, iwe unodawo kutarisa bhokisi riri pedyo navo, uye wobva wadzvanya "OK" pazasi pehwindo.

5. Chiziviso pamusoro pezvawanikwa zvakapetwa zvichaonekwa pachiratidziro. Dzichadzimwa otomatiki.

Zvinokosha! Mushure mekubvisa zvakapetwa kaviri, ndiro ichafanirwa kuunzwa kune "yakafanira" fomu nemaoko kana kushandisa iyo yekufomatisa sarudzo, nekuti mamwe makoramu nemitsara inogona kubuda.

Nzira 3: Kushandisa sefa yepamusoro

Iyi nzira yekubvisa duplicate ine nyore kuita. Kuti uipedze, iwe uchada:

1. Muchikamu che "Data", padivi pebhatani re "Sefa", tinya pashoko rekuti "Advanced". Hwindo reAdvanced Filter rinovhura.

2. Isa chinja chekuchinja padivi pemutsara we "Kopira mhinduro kune imwe nzvimbo" uye tinya pane icon iri padivi pe "Yekutanga renji" ndima.
3. Sarudza negonzo huwandu hwemaseru kwaunoda kutsvaga akadzokorora. Iwindo rekusarudza rinobva ravhara.
4. Tevere, mumutsara "Isa mhedzisiro muhuwandu", iwe zvakare unofanirwa kudzvanya LMB pane icon pamagumo uye sarudza chero sero kunze kwetafura. Ichi ndicho chichava chinhu chekutanga uko iyo yakagadziridzwa label ichaiswa.

5. Tarisa bhokisi "Chete akasiyana marekodhi" uye tinya "OK". Nekuda kweizvozvo, tafura yakagadziridzwa isina zvakapetwa ichaonekwa padivi pekutanga.

Mamwe Mashoko! Rudzi rwekare rwemasero runogona kudzimwa, zvichisiya chete iyo yakagadziriswa label.

Nzira 4: Shandisa PivotTables

Iyi nzira inotora kutevedzera inotevera nhanho-nhanho algorithm:

1. Wedzera koramu yebetsero kutafura yepakutanga woiverenga kubva pa1 kusvika kuN. N ndiyo nhamba yemutsara wekupedzisira munhevedzano.

2. Enda kuchikamu che "Insert" uye tinya bhatani re "Pivot Tafura".

3. Muhwindo rinotevera, isa shanduko mumutsara "Kune pepa riripo", mundima ye "Table or range", tsanangura huwandu hwemasero.
4. Mumutsara we "Range", tsanangura sero yekutanga umo tafura yakagadziridzwa inowedzerwa uye tinya pa "OK".

5. Mufafitera riri kuruboshwe kwepepa rebasa, tarisa mabhokisi ari pedyo nemazita emakoroni etafura.

6. Tarisa mhinduro.

mhedziso

Saka, kune nzira dzinoverengeka dzekubvisa zvakapetwa muExcel. Imwe neimwe yenzira dzavo inogona kunzi iri nyore uye inoshanda. Kuti unzwisise nyaya yacho, unofanira kunyatsoverenga mashoko ari pamusoro apa.