Chotsani Mipukutu Yomweyi ya Data mu Excel

01 a 02

Chotsani Duplicate Data Records ku Excel

Mapulogalamu apamwamba monga Excel nthawi zambiri amagwiritsidwa ntchito ngati ziwonetsero za zinthu monga zowonongeka, zolemba malonda, ndi mndandanda wamatumizi.

Maofesi a Excel ali ndi matebulo a deta omwe amawongolera mndandanda wa deta.

M'mbuyo, deta iliyonse kapena selo iliyonse mzerewu imagwirizana - monga dzina la kampani, adiresi ndi nambala ya foni.

Vuto lodziwika lomwe limapezeka ngati database likukula mu kukula ndi la zolembera zolemba kapena mizere ya deta.

Izi zikhoza kuchitika ngati:

• Zonse zolembedwera zimalowa mu databoloko kangapo kamodzi chifukwa cha zolemba ziwiri kapena zingapo zofanana
• Zolemba zambiri zimakhala ndi gawo limodzi kapena zambiri - monga dzina ndi adilesi - zomwe zili ndi deta yomweyo.

Njira iliyonse, zolembera zolembera zingayambitse mavuto ambiri - monga kutumizira makalata ambiri kwa munthu yemweyo pamene chidziwitso chachinsinsi chikugwiritsidwa ntchito pa makalata akuphatikizana - kotero ndibwino kuyesa ndikuchotsa zolemba zolembedwa nthawi zonse maziko.

Ndipo ngakhale kuti n'zosavuta kunyamula zolemba zochepa zofanana ndi zomwe zili mu chithunzi pamwambapa, matebulo a deta angathe kukhala ndi mazana ambiri ngati zolemba zambiri sizikupangitsa kuti zikhale zovuta kuti azilemba zolembera - makamaka zofanana ndi zolemba.

Kuti zikhale zosavuta kukwaniritsa ntchitoyi, Excel ili ndi zipangizo zamtundu wotchulidwa, osadabwitsa, Chotsani Duplicates , zomwe zingagwiritsidwe ntchito kupeza ndi kuchotsa zofanana ndi zofanana ndi zolemba.

Komabe, njira yomwe Chotsitsiramo Chophimba chidawongolera , zofanana ndi zofanana zolembera ziyenera kuthandizidwa payekha.

Izi ndi chifukwa Chotsitsa Chotsitsa Ma bokosi la bokosi chikuwonetsera mayina a masimu a tebulo ladasankhidwa ndipo mumasankha malo omwe mungaphatikizire mukufufuza zofanana ndizo:

• Kwa zofanana zolemba, fufuzani pazinthu zonse - kusiya zizindikiro zotsatila pafupi ndi maina onse a pamtunda kapena m'munda;
• Posiyanitsa pang'ono zolemba - kuchoka chizindikiro chachitsulo pafupi ndi malo okhawo oyenera kufanana.

Maina Amtunda ndi Malembo Olemba

Monga tafotokozera, Chotsani Chotsitsa Chida chimakhala ndi bokosi la dialog omwe mumasankha malo omwe mukufuna kuti mufufuze mwa kufufuza mayina kapena maina omwe mukufuna.

Zomwe ma bokosilo amasonyezera - maina a m'munda kapena makalata olembedwa - zimadalira ngati deta yanu ili ndi mndandanda wa mitu - kapena mitu - pamwamba pa tebulo la deta monga momwe taonera pa chithunzi pamwambapa.

Ngati atero - onetsetsani kuti njira yomwe ili kudzanja lamanja la bokosi la mafunso - Deta yanga ili ndi mutu - imachotsedwa ndipo Excel iwonetsa mayina mu mzerewu ngati mayina akumidzi mubox.

Ngati deta yanu ilibe mzere wa mutu, bokosilo liwonetseratu makalata oyenera omwe ali nawo mu bokosi la ma deta osiyanasiyana.

Zosintha Zambiri za Deta

Chotsani Chotsitsa Chida kuti mugwiritse ntchito bwino, tebulo la deta liyenera kukhala deta yambiri - yosayenera kukhala ndi mizere yopanda kanthu, ndizitsulo, ndipo ngati n'kotheka, palibe maselo opanda kanthu omwe ali mkati mwa tebulo.

Kusakhala ndi zizindikiro mkati mwa tebulo la deta ndizochita zabwino pankhani ya kasamalidwe ka deta zambiri komanso osati pofufuza deta yochepa. Zida zina za deta za Excel - monga kukonza ndi kusefera - zimagwira ntchito bwino pamene tebulo la deta liri deta yambiri.

Chotsani Duplicate Data Records Chitsanzo

Mu chithunzi pamwambapa, tebulo la deta liri ndi ziwerengero ziwiri zofanana za A. Thompson ndi zolemba ziwiri zofanana za R. Holt - kumene masewera onse amacheza kupatula nambala ya ophunzira.

Masitepe omwe ali pansipa tsatanetsatane momwe mungagwiritsire ntchito Chotsani Duplicates data tool to:

1. Chotsani kachiwiri kawiri zofanana zolemba za A. Thompson.
2. Chotsani nyimbo yachiwiri yofanana ndi R. Holt.

Kutsegula Chotsani Chotsitsa Bokosi la Dialog

1. Dinani pa selo iliyonse yomwe ili ndi deta muzitsanzo zachinsinsi.
2. Dinani tabu la Deta pamaboni.
3. Dinani pa Chotsani Duplicates icon kuti muwonetsetse deta yonse mu tebulo la deta ndikutsegula Chotsani Chotsitsa Cholozera.
4. Chotsitsa Chotsatira bokosi la bokosi chimasonyeza zonse zolemba mutu kapena mayina akumunda kuchokera ku deta yathu ya deta
5. Mayendedwe a cheke pambali pa maina a masamba amasonyeza kuti ma Excel am'mbali adzayesera kuti afufuze pofufuza zolembera zolembera
6. Mwachindunji, pamene bokosi lamasamba likutsegula mayina onse amtundu akuchotsedwa

Kupeza Zolemba Zofanana

1. Popeza tikufuna zolemba zofanana muzitsanzo izi tidzasiya zolemba zonsezo
2. Dinani OK

Panthawiyi zotsatira zotsatirazi ziyenera kuwonetsedwa:

• Bokosi la funso liyenera kutsekedwa ndi kusinthidwa ndi uthenga kuti: 1 zowerengera zomwe zimapezeka ndi kuchotsedwa; 7 zikhalidwe zosiyana zatsala.
• Mzere umene uli ndi zowerengera A. Chiwerengero cha Thompson chidzachotsedwa ku database
• Ngakhale pali zolemba ziwiri zofanana za R. Holt, chifukwa sizinthu zonse zomwe zimagwirizana - nambala ya wophunzira pazolembedwa ziwirizo - Excel ikuwona kuti ndi mbiri yapadera

02 a 02

Pezani ndi kuchotsa Zolemba Zofanana Zomwe Mumachotsa Zolemba

Kufufuza Munda Wamodzi Panthawi

Popeza Excel imachotsa chiwerengero cha deta zomwe zimagwirizana ndondomeko ya deta, njira yabwino yopezeramo zowerengera za data ndi kuchotsa chidziwitso cha munda umodzi panthawi imodzi, monga momwe zakhalira m'magulu otsatirawa.

Kufufuza kofufuza komwe kukufanana ndi madera onse kupatula dzina, zaka, kapena pulogalamu idzathetsa zonse zomwe zingatheke kuti zikhale zofanana ndi zolemba.

Kupeza Zolemba Zofanana Zogwirizana

1. Dinani pa selo iliyonse yomwe ili ndi deta mu tebulo la deta ngati kuli kofunikira
2. Dinani tabu la Deta pamaboni.
3. Dinani pa Chotsani Duplicates icon kuti muwonetsetse deta yonse mu tebulo la deta ndikutsegula Chotsani Chotsitsa Cholozera.
4. Maina onse amtunda kapena zigawo za pamutu pa tebulo ladeta amasankhidwa.
5. Kuti mupeze ndi kuchotsa zolemba zomwe sizikugwirizana m'minda iliyonse, chotsani chitsimikizo kupatulapo maina awo a ntchito omwe Excel amanyalanyaza.
6. Chitsanzo ichi dinani pabokosi la cheke pambali pa chikhomo cha Ophunzira a Mutu kuti muchotse chekeni.
7. Excel tsopano ingoyang'ana ndi kuchotsa zolemba zomwe zikufanana ndi Dina la Last Name , Initial , ndi Programs .
8. Dinani OK
9. Bokosi la funso liyenera kutsekedwa ndi kusinthidwa ndi uthenga kuti: 1 zowerengera zomwe zimapezeka ndi kuchotsedwa; 6 makhalidwe apadera amakhala.
10. Mzere umene uli ndi mbiri yachiwiri ya R. Holt ndi ID ya Ophunzira za ST348-252 idzachotsedwa ku deta.
11. Dinani OK kuti mutseke bokosi la uthenga

Pano, chitsanzo cha deta la deta chiyenera kukhala chaulere deta zonse.