Office
Sida loo helo loona saaro qiimayaasha nuqulka ah ee Excel
Tallaabo-tallaabo si loo helo qiimayaasha nuqulka ah ee Excel adigoo adeegsanaya Conditional Formatting, si loo saaro safafka nuqulka ah adigoo adeegsanaya Remove Duplicates, iyo sidii loo nadiifin lahaa xogta Excel ama CSV gudaha biraawsarka.
Haddii magac, email, koodh badeecad, ama lambarka dalabka uu marar badan ku soo noqnoqdo Excel, waxaad marka hore iftiimin kartaa nuqulkaas—ama tirtiri kartaa safafka dheeraadka ah.
Hubinta ugu dhaqsaha badan:
Raadi nuqulo: Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values
Ka saar nuqulo: Data → Remove Duplicates
Xitaa loogu talagalay xaashiyaha waaweyn ama faylasha CSV, waxaad sidoo kale ku nadiifin kartaa nuqullada gudaha biraawsarka adigoo adeegsanaya NEXNARA Data Cleaner & Filter.
Raadi qiimayaasha nuqulka ah ee Excel
Haddii aad rabto inaad aragto qiimayaasha soo noqnoqda ka hor intaadan tirtirin wax, isticmaal Conditional Formatting.
Jadwal tusaale:
| Customer ID | Name | |
|---|---|---|
| 1001 | John | john@example.com |
| 1002 | Sarah | sarah@example.com |
| 1003 | Mike | mike@example.com |
| 1004 | John | john@example.com |
Halkan, John iyo john@example.com waxay soo noqnoqdeen laba jeer.
Jidka menu:
Excel wuxuu midabeynayaa unugyada isku midka ah. Waxba lama tirtirayo—waxaad kaliya arkeysaa halka nuqulku ku jiraan.
Ka saar qiimayaasha nuqullada ah ee Excel
Markaad diyaar u tahay inaad tirtirto safafka dheeraadka ah, dooro xadka xogta, ka dibna fur Remove Duplicates.
In wadahadalka, dooro tiirarka Excel uu isticmaali doono si uu u go’aamiyo in laba saf ay isku mid yihiin. Xulashada tiirarkaasi ayaa bedesha natiijada.
Ogaanshaha nuqulladu waxay ku xiran tahay tiirarka aad doorato.
Tusaale:
Name | City
John | New York
John | Chicago
Sarah | Boston
Haddii aad kaliya hubiso Name, labada saf ee John labaduba waxay ka mid noqon karaan nuqullada.
Haddii aad hubiso Name iyo City, John + New York iyo John + Chicago waa isku-dhafka kala duwan—markaa ma aha nuqulo isku mid ah.
Xaqiiji liiska tiirka ka hor inta aanad socodsiin Remove Duplicates.
Buugaagta muhiimka ah, marka hore nuqul faylka. Remove Duplicates wuxuu ka tirtiraa safafka xaashida. Isla markiiba ka dib tallaabada, Ctrl+Z ayaa laga yaabaa inuu ka noqdo—laakiin kaydku waa ka ammaan badan yahay.
Nadiifi Excel ama CSV nuqulada online
Haddii aad doorbidayso inaad ka shaqeyso browser-ka—ama aad haysato CSV/TSV dhoofin—isticmaal Data Cleaner & Filter ee NEXNARA.
Waxaad furi kartaa Excel, CSV, ama TSV, ama dhaji kartaa jadwal. Kadibna hel safaf nuqul ah oo ku jira tiirarka la xushay, hayso nuqulkii ugu horreeyay, hayso nuqulkii ugu dambeeyay, ama ka saar saf kasta oo nuqul ah. Workspace-ka isku midka ah sidoo kale wuxuu taageeraa sifeynta, kala soocidda, goynta, raadinta iyo bedelidda, iyo dhoofinta dib CSV, XLSX, ama TSV.
Falanqaynta iyo nadiifinta waxay ka dhacaan biraawsarkaaga. NEXNARA ma soo galinayo warqadda xogta server.
Ma hayn karaa kaliya hal nuqul oo mid kasta oo nuqul ah?
Dad badan waxay haystaan safkii ugu horreeyay ee la jaan qaaday. Xogta waqtiga la habeeyey halkaas oo diiwaanka ugu dambeeya uu sii harayo, hayso safkii ugu dambeeyay. Data Cleaner wuxuu taageeraa Keep first, Keep last, iyo Remove all duplicates.
FAQ
Ma heli karaa nuqulo iyada oo aan la tirtirin?
Haa. Isticmaal Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values. Excel wuxuu kaliya iftiimiyaa unugyada.
Ma dhex celin karaa Remove Duplicates?
Mararka qaar haa, iyadoo Ctrl+Z isla markiiba falka ka dib la isticmaalayo. Si kastaba ha noqotee, kaydi faylasha muhiimka ah ka hor intaadan tirtirin safafka.
Ma u dajin karaa safafka sida nuqulo keliya marka dhowr column isku mid noqdaan?
Haa. Remove Duplicates, dooro column kasta oo ay tahay inay isku mid noqdaan. Excel wuxuu isbarbar dhigaa isku-darka column-yadaas.
Ma ka tirtiri karaa nuqulo fayl CSV ah?
Haa. Fur CSV gudaha Excel oo isticmaal Remove Duplicates, ama nadiifi gudaha NEXNARA Data Cleaner.
Ma 00123 iyo 123 waa isku qiimo?
Waxay noqon karaan isku mid haddii Excel u keydiyo sida lambarro oo baabi’iyo eberka hormoodka ah. Sii code-yada alaabta, code-yada boostada, iyo ID-yada shaqaalaha sida qoraal marka eberka hormoodka ah ay muhiim tahay.