Ib txoj haujlwm yooj yim: muaj ntau lub hlwb (cia peb hais A1: A10) qhov twg tus neeg siv nkag cov ntaub ntawv los ntawm cov keyboard. Nws yog ib qho tsim nyog los xyuas kom meej qhov tsis sib xws ntawm tag nrho cov nqi nkag, piv txwv li tiv thaiv tus neeg siv los ntawm kev nkag mus rau tus nqi yog tias nws twb muaj nyob rau hauv qhov ntau, piv txwv li tau qhia ua ntej.
Xaiv ib qho ntawm cov cell thiab nias lub pob Kev lees paub cov ntaub ntawv (Kev lees paub cov ntaub ntawv) tab Cov ntaub ntawv (Hnub). Hauv cov ntawv qub - Excel 2003 thiab ua ntej - qhib cov ntawv qhia zaub mov Cov ntaub ntawv - validation (Cov ntaub ntawv - validation). Hauv Advanced tab tsis (Chaw) los ntawm daim ntawv teev npe Cov ntaub ntawv hom (Pom) xaiv ib qho kev xaiv lwm yam (Kev Cai) thiab sau cov qauv hauv qab no rau hauv kab Formula (Formula):
=COUNTIF($A $1: $A $10;A1) <=1
los yog lus Askiv =COUNTIF($A$1:$A$10;A1)<=1
Lub ntsiab lus ntawm cov qauv no yooj yim - nws suav cov xov tooj ntawm tes hauv qhov ntau A1: A10 sib npaug rau cov ntsiab lus ntawm tes A1. Cov tswv yim yuav raug tso cai tsuas yog nyob rau hauv cov hlwb uas cov zauv tshwm sim tsawg dua los yog sib npaug rau 1. Ntxiv mus, qhov ntau yog teem nruj me ntsis (los ntawm cov ntaub ntawv tseeb nrog $ cov cim), thiab cov ntaub ntawv siv rau tam sim no ntawm tes A1 yog txheeb ze. Yog li, ib qho kev kuaj zoo sib xws yuav raug ua rau txhua lub xov tooj uas tau xaiv. Txhawm rau ua kom tiav daim duab, koj tuaj yeem mus rau lub tab hauv qhov rai no yuam kev cov lus (Kev ceeb toom yuam kev)thiab sau cov ntawv uas yuav tshwm sim thaum koj sim nkag duplicates:
Ntawd yog txhua yam - nyem OK thiab txaus siab rau cov tshuaj tiv thaiv ntawm lwm tus 🙂
Qhov kom zoo dua ntawm txoj kev no yog qhov yooj yim ntawm kev siv, thiab qhov tsis zoo yog tias nws yooj yim rau lov tes taw xws li kev tiv thaiv hauv tib lub thawv los yog los ntawm kev luam thiab pasting hlwb nrog duplicates rau hauv peb ntau yam. Tsis muaj kev txais tos rau cov khoom seem. Txhawm rau tiv thaiv cov neeg ua phem li no, tus neeg siv yuav tau ua kom muaj kev tiv thaiv tseem ceeb ntawm daim ntawv lo lus zais thiab sau ib qho tshwj xeeb macro los cuam tshuam kev luam.
Tab sis txoj kev no yuav tiv thaiv tag nrho tiv thaiv kev sib tsoo ntawm cov ntaub ntawv.
- Extracting tshwj xeeb nkag los ntawm ib daim ntawv teev npe
- Xim highlighting duplicates hauv ib daim ntawv
- Kev sib piv ntawm ob cov ntaub ntawv ntau yam
- Yuav rho tawm cov khoom tshwj xeeb los ntawm ib daim ntawv teev npe siv PLEX add-on.