Office
Yadda ake nemo da cire ƙimomin da suka maimaita a Excel
Mataki-mataki hanyoyin nemo ƙimomin da suka maimaita a Excel tare da Conditional Formatting, cire layuka masu maimaita tare da Remove Duplicates, da tsabtace bayanai na Excel ko CSV a cikin mai bincike.
Idan suna guda, imel, lambar samfur, ko lambar oda sun bayyana fiye da sau ɗaya a Excel, za ka iya haskaka waɗannan abubuwan da suka maimaita da farko—ko kuma goge ƙarin layuka.
Binciken da ya fi sauri:
Nemo abubuwan da suka maimaita: Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values
Cire abubuwan da suka maimaita: Data → Remove Duplicates
Ga manyan takardun aiki ko fayilolin CSV, za ka iya kuma tsabtace abubuwan da suka maimaita a cikin mai bincike tare da NEXNARA Data Cleaner & Filter.
Nemo ƙimomin da suka maimaita a Excel
Idan kana son ganin ƙimomin da ke maimaituwa kafin ka goge wani abu, yi amfani da Conditional Formatting.
Misali tebur:
| Customer ID | Name | |
|---|---|---|
| 1001 | John | john@example.com |
| 1002 | Sarah | sarah@example.com |
| 1003 | Mike | mike@example.com |
| 1004 | John | john@example.com |
A nan, John da john@example.com sun bayyana sau biyu.
Hanyar menu:
Excel yana launin sel ɗin da suka dace. Babu abin da aka goge—kawai za ka ga inda kwafi suke.
Cire ƙimar kwafi a Excel
Lokacin da ka shirya share ƙarin rijiyoyi, zaɓi zangon bayanai, sannan buɗe Remove Duplicates.
A cikin tattaunawar, zaɓi waɗanne ginshiƙai Excel zai yi amfani da su don yanke hukunci cewa rijiyoyi biyu suna daidai. Wannan zaɓin ginshiƙi yana canza sakamakon.
Ganewar kwafi yana dogara ne akan ginshiƙan da ka zaɓa.
Misali:
Name | City
John | New York
John | Chicago
Sarah | Boston
Idan ka duba kawai Name, duka rijiyoyin John na iya ƙidaya a matsayin kwafi.
Idan ka duba Name da City, John + New York da John + Chicago su ne haɗin daban—don haka ba kwafi ba ne.
Tabbatar da jerin ginshiƙai kafin gudanar da Remove Duplicates.
Ga manyan littattafan aiki, kwafi fayil ɗin da farko. Remove Duplicates yana share layuka daga takardar. Da zarar an kammala wannan matakin, Ctrl+Z na iya maido da shi—amma yin ajiyar baya ya fi aminci.
Tsaftace kwafi a Excel ko CSV akan layi
Idan kana so ka yi aiki a burauza—ko kana da fitarwa na CSV/TSV—yi amfani da Data Cleaner & Filter a NEXNARA.
Kuna iya buɗe Excel, CSV, ko TSV, ko liƙa tebur. Sannan ku nemo layukan maimaitawa a cikin ginshiƙai da aka zaɓa, ku riƙe daidai na farko, ku riƙe daidai na ƙarshe, ko ku cire kowane layi mai maimaitawa. Wannan wurin aiki ɗaya kuma yana goyan bayan tacewa, jera, gyara, nemo da maye gurbin, da kuma fitarwa zuwa CSV, XLSX, ko TSV.
Sarrafawa da tsaftacewa suna gudana a cikin burauzarka. NEXNARA baya loda fayil ɗin tebur zuwa uwar garken.
Ku riƙe guda ɗaya kawai na kowane maimaitawa?
Mafi yawan mutane suna riƙe da layin farko da ya dace. Don bayanan da aka tsara bisa lokaci inda sabon rikodi ya kamata ya kasance, ku riƙe layin ƙarshe. Data Cleaner yana goyan bayan Keep first, Keep last, da Remove all duplicates.
FAQ
Zan iya nemo maimaitawa ba tare da cire su ba?
I, Yi amfani da Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values. Excel yana nuna kawai sel.
Zan iya maido da Remove Duplicates?
Sau da yawa eh, tare da Ctrl+Z nan take bayan aikin. Duk da haka, ajiye muhimmancin fayiloli kafin cire layuka.
Shin zan iya ɗaukar layuka a matsayin maimaita kawai lokacin da ginshikan da dama suka dace?
Eh. A cikin Remove Duplicates, zaɓi kowanne ginshiƙi da dole ne su dace tare. Excel yana kwatanta haɗin waɗannan ginshikan.
Shin zan iya cire maimaita daga fayil ɗin CSV?
Eh. Bude CSV a Excel kuma yi amfani da Remove Duplicates, ko kuma tsaftace shi a NEXNARA Data Cleaner.
Shin 00123 da 123 ƙima ɗaya ne?
Zasu iya zama ɗaya idan Excel ya adana su a matsayin lambobi kuma ya cire sifili na farko. Riƙe lambobin samfur, lambobin gidan waya, da ID ɗin ma’aikata a matsayin rubutu lokacin da sifili na farko yake da mahimmanci.