Susa ama-Ruplicate Rows of Data ku-Excel

01 ngo-02

Susa amarekhodi weDiplicate Data ku-Excel

Susa Ukuphindaphinda - Ukusesha Amarekhodi Angaziwa Ngegama Legama. © Ted French

Izinhlelo zepredishithi ezifana ne-Excel zivame ukusetshenziswa njengezinqolobane zezinto ezinjengezinqolobane zezingxenye, amarekhodi okuthengisa, nezinhlu zokuposa.

Ulwazi oluse-Excel lunezibhebhe zedatha ngokuvamile ezihlelwe zibe imigqa yedatha ebizwa ngokuthi amarekhodi.

Emrekhodini, idatha eseliweni ngayinye noma enkambu emgqeni ihlobene - njengegama lenkampani, ikheli kanye nenombolo yocingo.

Inkinga evamile eyenzeka njengedatha yemininingwane ekhula ngobukhulu yilezi zerekhodi eziphindaphindiwe noma imigqa yedatha.

Lokhu kuphinda kungenzeka uma:

Noma iyiphi indlela, amarekhodi aphindwe angabangela izinkinga eziningi - njengokuthumela amakhophi amaningi kumadokhumenti kumuntu ofanayo uma imininingwane yolwazi isetshenziselwa ukuhlanganiswa kweposi - ngakho-ke kuwumqondo omuhle ukuskena nokususa amarekhodi aphindwe njalo isisekelo.

Futhi kuyilapho kulula ukukhetha amarekhodi aphindaphindiwe esampula encane njengaleyo esithombeni ngenhla, amatafula wedatha angaba kalula ngamakhulu uma kungenjalo izinkulungwane zamarekhodi enza kube nzima kakhulu ukukhetha amarekhodi aphindaphindiwe - amarekhodi athile ngokulinganayo.

Ukwenza kube lula ukufeza lo msebenzi, i-Excel inokwakhiwa kwithuluzi lwedatha elibizwa ngokuthi, akumangazi, Susa ama-Duplicates , angasetshenziselwa ukuthola nokukhipha amarekhodi afanayo kanye namarekhodi afanayo.

Kodwa-ke, indlela i- Remove Duplicates ithuluzi yakhelwe ngayo, amarekhodi afanayo afanayo futhi ahambisanayo kufanele athathwe ngokuhlukile.

Lokhu kungenxa yokuthi ibhokisi lebhokisi lebhokisi lokukhipha elibonisa ukubonisa amagama wamasimu etafuleni lemininingwane ekhethiwe futhi ukhetha ukuthi yiziphi izinkambu ezizozifaka ekufuneni amarekhodi afanayo:

Amagama ensimu namakholi ekholomu

Njengoba kukhonjisiwe, ithuluzi lokukhipha okukhipha lihlanganisa ibhokisi lengxoxo lapho ukhetha ukuthi yimaphi amasimu afanayo ofuna ukuwahlola ngokuhlola amagama asemasimini noma amakholomu ayifunayo.

Ulwazi oluboniswa ibhokisi lamabhokisi - amagama ensimu noma izinhlamvu zekholomu - kuxhomeke ukuthi ngabe idatha yakho iqukethe umugqa wezihloko - noma izinhloko - phezulu kwetafula yedata njengoba kuboniswe esithombeni ngenhla.

Uma wenza - qinisekisa ukuthi ukhetho ngakwesokudla ngakwesokudla kwebhokisi lengxoxo - Idatha yami inezinhlobonhlobo - ihloliwe futhi i-Excel izobonisa amagama kulolu hlu njengamagama ensimu ebhokisini lengxoxo.

Uma idatha yakho ingenayo umugqa wenhlokweni, ibhokisi lebhokisi lizobonisa izinhlamvu ezifanele ikholomu ebhokisini lengxoxo yebanga elikhethiwe lwedatha.

Uhlobo Olubanzi Lokwaziswa

Ukuze Susa Ukuphindaphinda ithuluzi lokusebenza kahle, ithebula lemininingwane kumele libe yindawo elandelanayo yedatha - okungukuthi akumele ibe nemigqa engenalutho, amakholomu, futhi uma kungenzeka, akukho amangqamuzana angenalutho aphakathi kwetafula.

Ukungenazikhala ngaphakathi kwetafula yedatha kuwumkhuba omuhle uma kuziwa ekuphathweni kwedatha ngokujwayelekile hhayi nje lapho ufuna idatha yedatha. Amanye amathuluzi wedatha we-Excel - njengokuhlunga nokuhlunga - asebenze kangcono uma ithebula lwedatha liluhlu olubanzi lwemininingwane.

Susa Isibonelo Sokurekhoda kwedatha Isibonelo

Emfanekisweni ngenhla, ithebula lwedatha liqukethe amarekhodi amabili efana no-A. Thompson kanye namarekhodi amabili ahambisana no R. Holt - lapho zonke izinsimu zihambelana ngaphandle kwenombolo yomfundi.

Izinyathelo ezibalulwe ngezansi imininingwane yokuthi ungasebenzisa kanjani i- Duplicate data tool to:

  1. Susa okwesibili kwamarekhodi amabili afana no-A. Thompson.
  2. Susa irekhodi elifanayo elilinganayo le-R. Holt.

Ukuvula ibhokisi lokuxoxwa lokukhipha

  1. Chofoza kunoma isiphi iseli equkethe idatha kwisitatimende sesampula.
  2. Chofoza ithebhu yedatha kwi-Ribbon.
  3. Chofoza ku- Susa Ukususa I- icon ukuze uqokomise yonke idatha kudatha yedatha futhi uvule ibhokisi lokungena eliphumayo.
  4. I- Duplicate ibhokisi lengxoxo ibonisa zonke izihloko zekholomu noma amagama ensimu kusuka kwisampula yedatha yethu
  5. Amakaki amasheya eduze kwamagama ensimu abonisa ukuthi yiziphi i-columns Excel ezozama ukufanisa ekufuneni amarekhodi aphindwe kabili
  6. Ngokuzenzakalelayo, lapho ibhokisi lebhokisi livula wonke amagama ensimu ahloliwe

Ukuthola Amarekhodi Angaziwa

  1. Njengoba sifuna amarekhodi aphelele ngokuphelele kulesi sibonelo sizoshiya zonke izihloko zekholomu zihloliwe
  2. Chofoza OK

Kuleli phuzu imiphumela elandelayo kufanele ibonwe:

02 ka 02

Thola futhi Susa Amarekhodi Ahambisana Ngokweqile ngokukhipha okufakiwe

Susa Ukuphindaphindiwe - Ukusesha Amarekhodi Ahambisana Ngokubambisana Ngegama Lensimu. © Ted French

Ukuhlola Insimu Enye Ngesikhathi

Njengoba i-Excel isusa kuphela amarekhodi wedatha afana ngqo namasimu akhethiwe yedatha, indlela engcono kakhulu yokuthola wonke amarekhodi wedatha ahambisanayo ukususa uphawu lokuhlola insimu eyodwa kuphela ngesikhathi, njengoba kwenziwa ezinyathelweni ezingezansi.

Ukuseshwa okulandelayo kwamarekhodi afana nawo wonke amasimu ngaphandle kwegama, ubudala, noma uhlelo kuzosusa zonke izinhlanganisela ezikhona zokurekhoda ngokulinganayo.

Ukuthola Amarekhodi Ahambisana Ngokuhlanganyela

  1. Chofoza kunoma isiphi iseli equkethe idatha kudatha yedatha uma kunesidingo
  2. Chofoza ithebhu yedatha kwi- Ribbon .
  3. Chofoza ku- Susa Ukususa I- icon ukuze uqokomise yonke idatha kudatha yedatha futhi uvule ibhokisi lokungena eliphumayo.
  4. Wonke amagama ensimu noma izihloko zekholomu yedatha yedatha zikhethiwe.
  5. Ukuze uthole futhi ususe amarekhodi angenayo imingcele kuzo zonke izinsimu, susa uphawu lokuhlola ngaphandle kwalawo magama ensimu i-Excel engayinaki.
  6. Kulesi sibonelo chofoza ebhokisini lokuhlola eceleni kwekholomu ye- ID yomfundi ehoxisa ukususa uphawu lokuhlola.
  7. I-Excel manje izosesha kuphela futhi isuse amarekhodi anemininingwane ehambisanayo emasimini e- Last , Initial , nohlelo .
  8. Chofoza OK
  9. Ibhokisi lebhokisi kumele livale futhi lilandelwe umlayezo othi: 1 amanani okuphindaphindiwe atholakele futhi asusiwe; 6 amanani ayingqayizivele ahlala.
  10. Umugqa oqukethe irekhodi lesibili ka-R. Holt ne-ID ye-Student ye- ST348-252 kuzosuswa kusukela ku-database.
  11. Chofoza OK ukuvala ibhokisi lomlayezo

Kuleli phuzu, ithebula lwedatha lenkomba kufanele libe mahhala kuwo wonke idatha ephindaphindiwe.