Ntchito yodziwika bwino yomwe imachitika nthawi ndi nthawi pamaso pa wogwiritsa ntchito aliyense wa Excel ndikufanizira magawo awiri ndi deta ndikupeza kusiyana pakati pawo. Njira yothetsera vutoli, pamenepa, imatsimikiziridwa ndi mtundu wa deta yoyamba.
Njira 1. Mndandanda wa Synchronous
Ngati mindandanda yalumikizidwa (yosanjidwa), ndiye kuti zonse zimachitika mophweka, chifukwa ndikofunikira, kwenikweni, kufananiza zikhalidwe zomwe zili m'maselo oyandikana a mzere uliwonse. Monga njira yosavuta kwambiri, timagwiritsa ntchito chilinganizo chofanizira zinthu zomwe zimapanga ma boolean pazotulutsa. WOONA (ZOONA) or KUnama (ZABODZA):
Chiwerengero cha zolakwika chikhoza kuwerengedwa motsatira ndondomekoyi:
=SUMPRODUCT(—(A2:A20<>B2:B20))
kapena mu Chingerezi =SUMPRODUCT(—(A2:A20<>B2:B20))
Ngati zotsatira zake ndi ziro, mndandandawo ndi wofanana. Apo ayi, ali ndi zosiyana. Njirayi iyenera kulembedwa ngati njira yotsatirira, mwachitsanzo, mutalowa mu selo, musakanize Lowani, Ndipo Ctrl + Shift + Lowani.
Ngati mukufuna kuchita chinachake ndi maselo osiyanasiyana, ndiye njira ina yofulumira idzachita: sankhani mizati yonse ndikusindikiza fungulo F5, kenako pa zenera lotseguka batani yosangalatsa (Wapadera) - Kusiyana kwa mizere (Kusiyana kwa mizere). M'mitundu yaposachedwa ya Excel 2007/2010, mutha kugwiritsanso ntchito batani Pezani ndi kusankha (Pezani & Sankhani) - Kusankha gulu la maselo (Pitani ku Special) tsamba Kunyumba (Kunyumba)
Excel idzawunikira ma cell omwe amasiyana ndi zomwe zili (mzere). Kenako akhoza kukonzedwa, mwachitsanzo:
- lembani ndi mtundu kapena mwanjira yowoneka bwino
- omveka ndi kiyi Chotsani
- lembani chilichonse nthawi imodzi ndi mtengo womwewo polowetsa ndikukanikiza Ctrl + Lowani
- Chotsani mizere yonse yokhala ndi maselo osankhidwa pogwiritsa ntchito lamulo Kunyumba - Chotsani - Chotsani mizere papepala (Kunyumba - Chotsani - Chotsani Mizere)
- etc.
Njira 2: Mndandanda Wosanja
Ngati mindandandayo ndi yosiyana kukula kwake ndipo sanasankhidwe (zinthu zili mu dongosolo losiyana), ndiye kuti muyenera kupita njira ina.
Yankho losavuta komanso lachangu kwambiri ndikulola kuwunikira mitundu yosiyanasiyana pogwiritsa ntchito masanjidwe okhazikika. Sankhani mitundu yonse iwiri yokhala ndi data ndikusankha pa tabu kunyumba - Mapangidwe Okhazikika - Onetsani malamulo a cell - Makhalidwe Obwereza:
Ngati mungasankhe njira chosatha, ndiye Excel iwonetsa machesi omwe ali pamndandanda wathu ngati kuli kotheka Wapadera - zosiyana.
Kuwunikira mitundu, komabe, sikoyenera nthawi zonse, makamaka pamagome akulu. Komanso, ngati zinthu zitha kubwerezedwa mkati mwa mindandanda yokha, ndiye kuti njirayi sigwira ntchito.
Kapena, mutha kugwiritsa ntchito COUNTIF (COUNTIF) kuchokera mgulu Chiwerengero, yomwe imawerengera kangati chinthu chilichonse kuchokera pamndandanda wachiwiri chimapezeka koyamba:
Ziro zotsatira zimasonyeza kusiyana.
Ndipo, potsiriza, "aerobatics" - mukhoza kusonyeza kusiyana kwa mndandanda wosiyana. Kuti muchite izi, muyenera kugwiritsa ntchito array formula:
Zikuwoneka zowopsa, koma zimagwira ntchito bwino 😉
- Onetsani zobwerezedwa pamndandanda ndi mtundu
- Kuyerekeza magawo awiri ndi chowonjezera cha PLEX
- Kuletsa kulowetsamo zobwereza