Yadda za a share duplicates a Excel

Yadda za a share duplicates a Excel

Yadda za a kawar da kwafi a cikin Excel

Yadda za a samo duplicates a Excel, share zane-zane a cikin Excel, kuma kawar da dalla-dalla a cikin Excel duka iri ɗaya ne, tare da aiki mai sauƙi wanda aka haɗa a cikin Excel don yin haɗin bayanai.

Da ke ƙasa, za mu kuma ba da shawara da wani bayani tare da Excel cire nau'in ƙididdigfi, wadda za a iya amfani dasu don gano duplicates a Excel da boye duplicates a cikin Excel, ba tare da dole su kawar da duplicates a cikin Excel ba.

Ɗaya daga cikin bayani mai sauri tare da button mai sauƙi don share duk nau'i, kuma daya bayani ta amfani da ayyuka da ƙididdiga, kadan mafi rikitarwa, don gano su.

Yadda za'a kawar da duplicates a Excel

Yin umurni da jerin da cire duplicates yana aiki ne na yau da kullum da amfani, yayin aiki tare da jerin bayanai: adiresoshin imel, lambobi, dabi'u, ...

Wata mafita don aiwatar da babban tsari na bayanai zai iya amfani da Notepad ++.

Wani yiwuwar yana amfani da Excel 2013 daga Microsoft Office 2013.

Yadda za a cire duplicates a Excel

Farawa tare da saitin bayananku, zaɓi shafin (s) wanda kuke son cire duplicates.

Sa'an nan kuma, daga DATA menu, zaɓa zaɓin "Cire Duplicate" zažužžukan.

A cikin farfadowa, zaɓi idan bayaninka yana da rubutun kai ko a'a (ma'anar, layin farko wanda ba za a dauka a cikin aiki ba), da ginshiƙan da kake so ka duba, kuma danna Ok. Wannan shi ne yadda za a cire zane-zane a cikin Excel!

Har ma yana aiki tare da ginshiƙai biyu, ginshiƙai guda uku, ko fiye. Duk abin da za ku yi, ana zaɓi kamar ginshiƙai da yawa sun ƙunshi bayanai kamar yadda ya cancanta, kuma wannan aikin zai share duplicates. Wannan shi ne yadda za a kwatanta ginshiƙai guda biyu don samo duplicates a Excel, kuma aiki tare da wasu ginshiƙai idan ya cancanta.

Ya kamata ku sami tabbaci tare da adadin duplicates sharewa da kuma sauran ƙididdiga masu yawa.

A ƙarshe, zaku iya sozantar da bayanan, yanzu an cire duplicates, don samun jerin tsabta.

Tsayawa da zaɓinku, a cikin wannan DATA menu, zaɓi hawan hawa ko saukowa, kuma haka!

Tsara ko dai daga mafi ƙanƙanci zuwa mafi girma, ko daga mafi girma zuwa smalles, dangane da bayanan da aka saita, da kuma bukatar da shi.

Ɓoye duplicates a Excel

Don ɓoye duplicates a cikin Excel, kuma kuyi bayanan bayanai wanda zai kiyaye dukkanin bayananku maimakon kawar da duplicates, yi wadannan. Har ila yau wata hanya ce ta yadda za a gano duplicates a Excel tare da siffofi, maimakon yin amfani da aikin. Zai kuma sami dabi'u masu mahimmanci a cikin ginshiƙai masu mahimmanci na Excel, a cikin wasu matakai mai sauƙi da sauƙi:

  • Ƙara sabon shafi a cikin bayanan da aka saita, ko dai kafin ko bayan bayanan,

  • Rubuta bayanan ta shafi. Idan ginshiƙai biyu ko fiye sun cancanci yin rajista, ƙirƙira wani shafi tare da ƙaddamar da waɗannan ginshiƙai guda biyu ko fiye, da kuma yin umarni ta wannan ƙaddamarwa,

  • A cikin kullin jigon, ƙara maƙallan da aka biyo baya (idan shafi na A da kuma na farko maras asali ne A2, kuma B2 shine sel na farko don bincika dikali).

Formula don samo duplicates a Excel

=if(A2=B3;"Duplicate";"Original")

Ƙara haske a cikin layuka a Excel

Yanzu, kawai zaɓi dukkan layuka tare da darajar Kwafi a shafi na A, sa'annan ka haskaka su!

Nemi duplicates a cikin Excel

Dukkan abubuwan da aka kwatanta yanzu an gano, kuma zaka iya yin abin da kake so tare da su: haskaka zane-zane, ɓoye duplicates, ko kuma ganin yadda za a share zane-zane a cikin Excel, ...

Excel cire duplicates daga shafi

Don cire duplicates, ko ɓoye duplicates a cikin Excel, kawai tace a shafi A darajar daidai da Kwafi, kuma yi aikin daidai. Wannan shi ne yadda za a share duplicates a cikin Excel 2013, don yin Excel cire fayiloli daga jerin, amma kuma yadda za a cire duplicates a Excel 2013.

Kira kirkira a Excel

Don ƙididdige duplicates, a cikin takarda na yanzu, ƙara mahallin marar dama a gefen dama na shafi tare da kwatanta aikin, tace a kan shafi A Daidaicin Ƙa'idar, kuma ƙara da wannan maƙala a shafi na B. Ya kamata ka kasance da maɓallin a shafi na C :

=countif(C:C;A2)

Kuma mika wannan dabara zuwa dukan shafi. Saboda haka zai nuna yawan adadin kalmomi don kowane darajar!

Similar articles

Sharhis (0)

Leave a comment