Yadda ake Nemo Duplicate Values ​​a cikin ginshiƙi na tebur na Excel

Tebur mai kima iri ɗaya babbar matsala ce ga yawancin masu amfani da Microsoft Excel. Za'a iya cire bayanan maimaitawa ta amfani da kayan aikin da aka gina a cikin shirin, yana kawo tebur zuwa kyan gani na musamman. Yadda za a yi shi daidai za a tattauna a wannan labarin.

Hanyar 1 Yadda za a duba tebur don kwafi kuma cire su ta amfani da kayan aiki na Yanayi

Don kada a kwafin wannan bayanin sau da yawa, dole ne a nemo shi kuma a cire shi daga tsararrun tebur, barin zaɓi ɗaya kawai. Don yin wannan, kuna buƙatar yin matakai masu zuwa:

1. Yi amfani da maɓallin linzamin kwamfuta na hagu don zaɓar kewayon sel waɗanda kuke son bincika bayanan kwafi. Idan ya cancanta, zaku iya zaɓar teburin duka.
2. A saman allon, danna kan "Home" tab. Yanzu, a ƙarƙashin Toolbar, ya kamata a nuna wani yanki tare da ayyukan wannan sashe.
3. A cikin sashin "Styles", danna-hagu akan maballin "Tsarin Yanayi" don ganin yuwuwar wannan aikin.
4. A cikin mahallin mahallin da ya bayyana, nemo layin “Ƙirƙiri doka…” kuma danna kan shi tare da LMB.

5. A cikin menu na gaba, a cikin sashin "Zaɓi nau'in mulki", kuna buƙatar zaɓar layin "Yi amfani da dabara don tantance sel da aka tsara."
6. Yanzu, a cikin layin shigar da ke ƙasan wannan sashe, dole ne ka shigar da dabarar da hannu daga madannai "= COUNTIF($B$2:$B$9; B2)>1". Haruffa a cikin baka suna nuna kewayon sel waɗanda za a yi tsarawa da neman kwafi. A cikin maɓalli, wajibi ne a tsara takamaiman kewayon abubuwan tebur da rataya alamun dala akan sel don kada dabarar ta “fita” yayin tsarin tsarawa.

7. Idan ana so, a cikin menu na “Ƙirƙiri tsarin tsarawa”, mai amfani zai iya danna maɓallin “Format” don tantance launin da za a yi amfani da shi don haskaka kwafi a cikin taga na gaba. Wannan ya dace, saboda maimaita dabi'u suna kama ido nan da nan.

Kula! Kuna iya samun kwafi a cikin maƙunsar bayanai na Excel da hannu, ta ido, ta hanyar duba kowane tantanin halitta. Koyaya, wannan zai ɗauki mai amfani lokaci mai yawa, musamman idan ana duba babban tebur.

Hanyar 2: Nemo kuma cire kwafin dabi'u ta amfani da maɓallin Cire Kwafi

Microsoft Office Excel yana da fasali na musamman wanda ke ba ku damar cire sel nan da nan tare da kwafin bayanai daga tebur. Ana kunna wannan zaɓi kamar haka:

1. Hakanan, haskaka tebur ko takamaiman kewayon sel a cikin takaddar aikin Excel.
2. A cikin jerin kayan aikin da ke saman babban menu na shirin, danna kalmar "Data" sau ɗaya tare da maɓallin linzamin kwamfuta na hagu.
3. A cikin sashin "Aiki tare da bayanai", danna maɓallin "Share kwafi".

4. A cikin menu wanda ya kamata ya bayyana bayan yin magudin da ke sama, duba akwatin kusa da layin "Bayanai na" yana ƙunshe da masu kai. A cikin sashin "Columns", za a rubuta sunayen duk ginshiƙan farantin, kuma kuna buƙatar duba akwatin kusa da su, sannan danna "Ok" a ƙasan taga.

5. Sanarwa game da kwafi da aka samo zai bayyana akan allon. Za a share su ta atomatik.

Muhimmin! Bayan cire kwafin dabi'u, farantin zai zama dole a kawo fom ɗin "daidai" da hannu ko amfani da zaɓin tsarawa, saboda wasu ginshiƙai da layuka na iya fita.

Hanyar 3: Amfani da ingantaccen tacewa

Wannan hanyar cire kwafi yana da sauƙin aiwatarwa. Don kammala shi, kuna buƙatar:

1. A cikin sashin "Data", kusa da maɓallin "Tace", danna kalmar "Advanced". Babban Tace taga yana buɗewa.

2. Sanya maɓallin juyawa kusa da layin "Kwafi sakamakon zuwa wani wuri" kuma danna gunkin da ke kusa da filin "Farko".
3. Zaɓi tare da linzamin kwamfuta kewayon sel inda kake son nemo kwafi. Tagan zaɓin zai rufe ta atomatik.
4. Na gaba, a cikin layin "Sakamakon wuri a cikin kewayon", kuna buƙatar danna LMB akan gunkin da ke ƙarshen kuma zaɓi kowane tantanin halitta a wajen tebur. Wannan shine farkon kashi inda za'a saka alamar da aka gyara.

5. Duba akwatin "Littattafai na musamman kawai" kuma danna "Ok". Sakamakon haka, tebur da aka gyara ba tare da kwafi ba zai bayyana kusa da tsararrun asali.

Ƙarin Bayani! Ana iya share tsohuwar kewayon sel, barin lakabin da aka gyara kawai.

Hanyar 4: Yi amfani da PivotTables

Wannan hanyar tana ɗaukar bin bin algorithm mataki-mataki mai zuwa:

1. Ƙara ginshiƙi na taimako zuwa ainihin tebur kuma ƙidaya shi daga 1 zuwa N. shine lambar layin ƙarshe a cikin tsararru.

2. Je zuwa sashin "Saka" kuma danna maɓallin "Pivot Table".

3. A cikin taga na gaba, sanya maɓallin juyawa a cikin layin "Zuwa takardar da ke akwai", a cikin filin "Table ko kewayon", ƙayyade takamaiman kewayon sel.
4. A cikin layin "Range", saka tantanin farko inda za'a ƙara tsararrun tebur da aka gyara sannan danna "Ok".

5. A cikin taga a gefen hagu na takaddar aikin, duba kwalaye kusa da sunayen ginshiƙan tebur.

6. Duba sakamakon.

Kammalawa

Don haka, akwai hanyoyi da yawa don cire kwafi a cikin Excel. Kowace hanyoyin su za a iya kira mai sauƙi da tasiri. Don fahimtar batun, dole ne ku karanta bayanan da ke sama a hankali.