Lokacin aiki tare da tebur ko database tare da adadin bayanai, yana yiwuwa wasu layuka maimaitawa. Wannan ya kara haɓaka bayanai. Bugu da ƙari, a gaban duplicates, ƙidayar lissafi na sakamako a cikin matakai mai yiwuwa ne. Bari mu ga yadda za a sami kuma cire layi biyu a cikin Microsoft Excel.
Nemo kuma share
Nemo kuma share dabi'u masu ladabi da aka ƙididdige, yiwu a hanyoyi daban-daban. A cikin waɗannan ɗayan waɗannan zaɓuɓɓukan, bincike da kawar da duplicates sune haɗin kai a cikin tsari daya.
Hanyar 1: sharewa ta sauƙaƙe na layuka biyu
Hanyar mafi sauki don cire duplicates shine amfani da maɓalli na musamman a kan tef ɗin da aka tsara domin wannan dalili.
- Zaži dukan layin tebur. Jeka shafin "Bayanan". Muna danna maɓallin "Cire Duplicates". Ana samuwa a kan tef a cikin asalin kayan aiki. "Yin aiki tare da bayanai".
- Ƙwaƙwalwar matsala ta biyu ta buɗe. Idan kana da tebur tare da rubutun kai (kuma a cikin mafi rinjaye yawancin shine ko yaushe shari'ar), to, game da saiti "Bayanan na yana ƙunshe da maɓallai" ya kamata a zana. A cikin babban filin filin akwai jerin ginshikan da za a bincika. Za'a yi la'akari da jerin jeri guda biyu kawai idan bayanai na dukan ginshiƙan da aka lakafta da alama ta alama. Wato, idan ka cire alamar rajista daga sunan wani shafi, to hakan yana fadada yiwuwar fahimtar rikodin kamar yadda aka maimaita. Bayan duk saitunan da aka buƙata, an danna maballin. "Ok".
- Excel yayi aikin don ganowa da cire duplicates. Bayan an kammala shi, bayanan bayanin ya bayyana, wanda ya gaya maka yawan adadin da aka ci gaba da cirewa da kuma yawan adadin sauran rubutun. Don rufe wannan taga, danna maballin. "Ok".
Hanyar 2: Cire Duplicates a cikin Smart Table
Duplicates za a iya cire daga kewayon sel ta hanyar kirkiro tebur mai mahimmanci.
- Zaži dukan layin tebur.
- Da yake cikin shafin "Gida" danna maballin "Girma a matsayin tebur"located a kan tef a cikin block of kayayyakin aiki "Sanya". A cikin jerin da ya bayyana, zaɓi kowane salon da kake so.
- Sa'an nan kuma karamin taga yana buɗe inda kake buƙatar tabbatar da zaɓin da aka zaba don samar da launi mai mahimmanci. Idan ka zaba duk abin da daidai, to sai ka tabbatar, idan ka yi kuskure, to wannan taga ya kamata a gyara. Yana da mahimmanci a kula da gaskiyar cewa game da "Launin da rubutun" akwai alamar. Idan ba, to, ya kamata a saka. Bayan an kammala saitunan, danna kan maballin. "Ok". Smart Table ya halitta.
- Amma ƙirƙirar "tebur mai mahimmanci" kawai mataki ne kawai don warware aikinmu na musamman - kawar da duplicates. Danna kan kowane tantanin halitta a cikin tebur. Ƙarin ƙungiyar tabs na bayyana. "Yin aiki tare da Tables". Da yake cikin shafin "Ginin" danna maballin "Cire Duplicates"wanda aka samo a kan tef a cikin asalin kayan aiki "Sabis".
- Bayan haka, maɓallin cirewa na biyu ya buɗe, aikin da aka kwatanta dalla-dalla lokacin da aka kwatanta hanyar farko. Dukkan ayyukan da aka yi a daidai wannan tsari.
Wannan hanya ita ce mafi kyau da kuma aikin duk abin da aka bayyana a cikin wannan labarin.
Darasi: Yadda za a sanya saitunan rubutu a cikin Excel
Hanyar 3: Aiwatar da zanewa
Wannan hanya ba ta cire cikakkun bayanai ba, tun da irin wannan yana ɓoye rubutun maimaita a cikin tebur.
- Zaɓi tebur. Jeka shafin "Bayanan". Muna danna maɓallin "Filter"located a cikin saituna block "Tsara da tace".
- Ana kunna tace, kamar yadda aka nuna ta wurin gumakan da suka bayyana a cikin nau'i-nau'i masu juyawa a cikin sunayen sunaye. Yanzu muna bukatar mu saita shi. Danna maballin "Advanced"yana kusa da kowane abu a cikin rukuni na kayan aiki "Tsara da tace".
- Maɓallin taga mai zurfin ya buɗe. Sanya alamar gaban gaban saiti "Kawai kawai shigarwar". Duk sauran saituna suna barin azaman tsoho. Bayan wannan latsa maɓallin "Ok".
Bayan haka, zakulo shigarwar za a ɓoye. Amma ana iya nuna su a kowane lokaci ta latsa maɓallin kuma. "Filter".
Darasi: Babban Filin Excel
Hanyar 4: Tsarin Yanayi
Hakanan zaka iya samun kundin jimloli ta yin amfani da matakan layi. Gaskiya ne, za a cire su tare da wani kayan aiki.
- Zaɓi wuri na tebur. Da yake cikin shafin "Gida"danna maballin "Tsarin Yanayin"located a cikin saituna block "Sanya". A cikin menu wanda ya bayyana, mataki zuwa mataki "Dokokin zabin" kuma "Duplicate values ...".
- Tsarin saitin tsarawa ya buɗe. Na farko saiti a ciki an bar canzawa - "Duplicate". Amma a cikin zaɓin zaɓi, za ka iya barin barin saitunan tsoho ko zaɓi kowane launi da ya dace maka, sannan ka latsa maɓallin "Ok".
Bayan wannan, za a zaɓa sassan da lambobi masu yawa. Idan kuna so, zaku iya share waɗannan kwayoyin ta hannu tare da hanya mai kyau.
Hankali! Bincike duplicates ta yin amfani da tsarin kwakwalwa ba a yi a kan layin a matsayin cikakke ba, amma a kan kowane tantanin halitta, saboda haka ba dace da duk lokuta ba.
Darasi: Tsarin Yanayi a Excel
Hanyar 5: ta yin amfani da tsari
Bugu da ƙari, ana iya samun duplicates ta hanyar yin amfani da wannan matsala ta amfani da ayyuka da yawa a lokaci daya. Tare da taimakonsa, zaka iya bincika duplicates a kan wani shafi na musamman. Tsarin al'ada na wannan tsari zaiyi kama da haka:
= IF ERROR (INDEX (column_address; MATCH) (0; comp.
- Ƙirƙiri wani shafi na raba inda za a nuna duplicates.
- Shigar da samfurin don samfurin da aka samo a cikin farkon salula na sabon shafi. A cikin yanayinmu na musamman, wannan tsari zai zama kamar haka:
= IF ERROR (INDEX (A8: A15; MATCHES (0; Accounts (E7: $ E $ 7; A8: A15) + IF (ACKS: A8: A15; A8: A15)> 1; 0; 1); 0)); "") - Zaɓi kowane shafi don duplicates, sai dai don rubutun kai. Saita siginan kwamfuta a ƙarshen wannan tsari. Latsa maballin akan keyboard F2. Sa'an nan kuma danna maɓallin haɗin Ctrl + Shigar + Shigar. Wannan shi ne saboda yanayin da ake amfani da su don yin amfani da su.
Bayan wadannan ayyukan a cikin shafi "Duplicates" Lambobin duplical suna nunawa.
Amma, wannan hanya har yanzu yana da rikitarwa ga mafi yawan masu amfani. Bugu da ƙari, yana ƙunshe ne kawai da nema don samfurori, amma ba a cire su ba. Saboda haka, ana bada shawara don amfani da mafita mafi sauki da kuma aikin da aka bayyana a baya.
Kamar yadda ka gani, a cikin Excel akwai kayan aikin da aka tsara domin nemanwa da kuma share duplicates. Kowannensu yana da halaye na kansa. Alal misali, fasalin yanayin ya shafi bincike ne kawai don kowannen tantanin halitta. Bugu da ƙari, ba duk kayan aiki ba kawai zai iya bincika ba, amma kuma share nau'ikan biyun. Mafi kyawun duniya shine don ƙirƙirar tebur mai mahimmanci. Lokacin amfani da wannan hanyar, za ka iya siffanta binciken don ƙwaƙwalwa kamar yadda ya dace da dacewa yadda ya kamata. Bugu da ƙari, cire su ya faru nan take.
