Bvisa Duplicate Rows of Data muExpcel

01 ye 02

Bvisa Duplicate Data Records mu Excel

Mapurogiramu epadheseti akadai saExcel anowanzoshandiswa sehuwandu hwezvinhu zvakadai sezvikamu zvekutsvaga, zvinyorwa zvekutengesa, uye mazita ekunyora.

Databases mu Excel inosanganisira mabwendefa e data anowanzogadzirirwa mumitsara yedata inonzi marekhodi.

Mune zvinyorwa, dhesi rimwe nerimwe rega kana munda mumutsara rinobatana - rakadai sezita rekambani, kero uye nhamba yefoni.

Dambudziko rinowanzoitika se database rinokura muhukuru nderokunyora zvinyorwa kana mitsara yedata.

Izvi zvinogona kuitika kana:

• Zvose zvinyorwa zvakapinda mune dhesiki kanopfuura kamwe zvichikonzerwa nemabhuku maviri kana kupfuura akafanana
• Zvinyorwa zvakawanda zvine imwe kana kupfuura minda - yakadai sezita nekero - rine data imwe chete.

Chero nzira, zvinyorwa zvinyorwa zvinogona kukonzera kuwanda kwematambudziko - sekudai kutumira makopi akawanda emapepa kumunhu mumwe chete apo dheinhau rekushandisa rinoshandiswa mumeseji kuungana - saka icho chinhu chakanaka chokutsvaga uye kubvisa zvinyorwa zvinyorwa pane nguva dzose basis.

Uye kunyange zvazvo zviri nyore kusarudza zvinyorwa zvinyorwa mune imwe sampuro shoma seyo iri mumufananidzo uri pamusoro, tafura dzematare dzinogona kunge dziine mazana emazana kana zvisiri zvemarekhodi zvichiita kuti zvive zvakaoma kutora zvinyorwa zvinyorwa-kunyanya zvishoma zvakafanana zvinyorwa.

Kuti zviite kuti zvive nyore kuita basa iri, Excel yakavakwa mumichina yedhairi inonzi, hazvishamisi, Bvisa Duplicates , iyo inogona kushandiswa kuwana uye kubvisa zvakafanana uye zvishoma nezvimwe zvinyorwa.

Zvisinei, nzira iyo Kubvisa Duplicates tool yakagadzirirwa, yakafanana uye yakaenzana nemafereti akafanirwa inofanira kutarisirwa zvakasiyana.

Izvi ndezvokuti Bvisa Duplicates dialog box rinoratidza mazita emumunda etafura ye data yakasarudzwa uye iwe unosarudza mazita aunofanira kuisa mune kutsvaga kwemarenda akafanana:

• Nokuda kwezvinyorwa, tsvaga mimwe minda - siya chekucherechedza matanho ari pedyo nemazita ose emakolomunda kana mashizha;
• Nokuda kwekuenzanisa zvinyorwa - kusiya chekucherechedza matanho pedyo neavo chete masimi akafananidzwa.

Mazita Emunda vs. Mavara Ekunyora

Sezvakataurwa, Bvisa Duplicates tool inosanganisira bhokisi rebhokisi apo unosarudza iyo inofanirwa neminda yekutsvaga nekutarisa pamunda unoda kana ma column.

Mashoko ayo ebhokisi rebhokisi rinoratidza - mazita emumunda kana mabhii ekorome-anobva pakuti kana data yako ine mutsara wemisoro-kana misoro - pamusoro peetafura yedeta sezvinoonekwa mumufananidzo uri pamusoro.

Kana ikadaro-iva nechokwadi chokuti sarudzo iri kuruoko rworudyi rwebhokisi rebhokisi - Data yangu ine musoro -inotarirwa uye Excel icharatidza mazita mumutsara uyu semazita emumunda mubhokisi rebhokisi.

Kana deta yako isina mutsara wemusoro, bhokisi rebhokisi richaratidza zvakakodzera mairasi mubhokisi yebhokisi yehurukuro yakasarudzwa yedata.

Zvinokonzera Range Data

Pamusoro peKubvisa Duplicates chigamba chekushanda zvakanaka, tafura ye data inofanira kunge yakanyatsotarisa deta - iyo haifaniri kuva nemitsetse isina chinhu, mapurumoni, uye, kana zvichibvira, pasina masero asina chinhu ari mukati metafura.

Kusava nemabhadhari mukati mefurafura yedhayamato maitiro akanaka kana zvasvika pakugadzirisa deta munharaunda uye kwete kwete apo uchitsvaga zvinyorwa zvinyorwa. Zvimwe zvinoshandiswa nedzimwe shandiso dzeDexcel - zvakadai sokusarudza uye kuchenesa - zvinoshanda zvakanyanya apo tafura yezvinyorwa ibasa rakawandisa re data.

Bvisa Duplicate Data Records Muenzaniso

Mumufananidzo uri pamusoro, tafura yezvinyorwa ine zvinyorwa zviviri zvakafanana zveA Thompson uye zvinyorwa zviviri zvakaenzanirana zveR. R. - apo mashizha ose anowirirana kunze kweiyo nhamba yevadzidzi.

Matanho ari pasi apa tsanangudzo yekuti ungashandisa sei Bvisa Duplicates data tool ku:

1. Bvisa wechipiri chezvinyorwa zviviri zvakafanana zveAlex Thompson.
2. Bvisa wechipiri chikamu chakafanana neRir Holt.

Kuvhura Bvisa Dupfu Bhokisi reDhialog

1. Dzvanya pane chero sero rine data pane shanduro yezvinyorwa.
2. Dzvanya Data Data pane irobhoni.
3. Dzvanya paDzimai Duplicates icon kuisa deta yose mudhesi re data uye kuti uzarure Dhinda Duplicates dialog box.
4. Bvisa Duplicates dialog box inoratidza zvose zvinyorwa zvitsvene kana mazita emumunda kubva kudu data samples
5. Iko hunotsvaira pedyo nemazita emumunda inoratidza kuti ma column e Excel anoedza kuenzanisa pakutsvaga zvinyorwa zvinyorwa
6. Nokusingaperi, apo bhokisi rebhokisi rinosvinura mazita ose emumunda anotariswa

Kuwana Zvinyorwa Zvakajeka

1. Sezvo tiri kutsvaga zvakakwana zvakanyorwa zvinyorwa mumuenzaniso uyu tichasiya zvose zvinyorwa zvinyorwa zvichitsvaga
2. Dzvanya OK

Panguva ino zvinotevera zvinofanira kuonekwa:

• Bhokisi rebhokisi rinofanira kuvhara nekudzoserwa neshoko richiti: 1 nyaya dzinowanikwa dzakawanikwa uye dzakabviswa; 7 akasiyana-siyana maitiro anoramba aripo.
• Mutsara waiva nezvinyorwa zvakaitwa A. Thompson rekodha ichabviswa kubva pane dhesi
• Kunyange zvazvo pane zvikamu zviviri zvakafanana zvinyorwa zveR. Holt, nokuti haisi dzose masikati akafananidzwa - nhamba yevadzidzi yemabhuku maviri akasiyana - Excel inofunga kuti iyo yakanyora nhoroondo

02 of 02

Tsvaga uye Bvisa Zvimwe Zvinyorwa Zvinyorwa neBvisa Duplicates

Kuongorora Munda Mumwe Penguva

Kubva pane Excel chete inobvisa zvinyorwa zvemashoko zvinonyatsofanana nemasarudzo akasarudzwa e data, nzira yakanakisisa yekuwana zvose zvinyorwa zvese zvakanyatsodonongodzwa zvekutsvaga ndeyekubvisa check check for field imwe chete panguva, sezvinoitwa mumatanho ari pasi apa.

Mukutsvaga kutsvaga marekodhi anowirirana mundima dzose kunze kwezita, zera, kana purogiramu ichabvisa zvose zvinokwanisika kusanganiswa kwekuenzanisa zvinyorwa.

Kutsvaga Zvinyorwa Zvinyorwa Zvakafanana

1. Dzvanya pane chero sero rine data pane tafura yezvinyorwa kana zvichidikanwa
2. Dzvanya Data Data pane irobhoni .
3. Dzvanya paDzimai Duplicates icon kuisa deta yose mudhesi re data uye kuti uzarure Dhinda Duplicates dialog box.
4. Mazita ose emumunda kana zvinyorwa zvepahombekeri yefurafura yedhadha anosarudzwa.
5. Kuti uwane uye kubvisa zvinyorwa zvisingabatanidzi mumunda wose, bvisa check check kubva kune mamwe mazita emumunda ayo Excel isingafariri.
6. Nokuda kwemuenzaniso uyu chengetedza pane bhokisi rekutarisa riri pedyo neVadzidzi veIndaneti mutsara unobvisa kubvisa check check.
7. Excel ikozvino ingongotsvaga uye kubvisa zvinyorwa zvine maonero akafanana muZita rekupedzisira , Initial , uye Programme masikati.
8. Dzvanya OK
9. Bhokisi rebhokisi rinofanira kuvhara nekudzoserwa neshoko richiti: 1 nyaya dzinowanikwa dzakawanikwa uye dzakabviswa; 6 nheyo dzakasiyana dzinoramba.
10. Mutsara waiva nechechi yechipiri yaR. R. Holt neDhidzi yeVadzidzi ve ST348-252 ichabviswa kubva pane dhesi.
11. Dzvanya OK kuti uvhare bhokisi remashoko

Panguva ino, muenzaniso wefurafura yedhadharo inofanira kuva isina mahwendefa ose ezvinyorwa.