Umsebenzi ojwayelekile ovela ngezikhathi ezithile ngaphambi komsebenzisi ngamunye we-Excel ukuqhathanisa izigaba ezimbili nedatha futhi uthole umehluko phakathi kwazo. Indlela yesixazululo, kulokhu, inqunywa uhlobo lwedatha yokuqala.
Inketho 1. Uhlu Oluvumelanayo
Uma izinhlu zivumelaniswa (zihlungiwe), khona-ke konke kwenziwa kalula, ngoba kuyadingeka, eqinisweni, ukuqhathanisa amanani kumaseli aseduze omugqa ngamunye. Njengenketho elula, sisebenzisa ifomula yokuqhathanisa amanani, ekhiqiza amanani we-boolean ekuphumeni. TRUE (IQINISO) or AMANGA (AMANGA):
Inani lokungafani lingabalwa ngefomula:
=SUMPRODUCT(—(A2:A20<>B2:B20))
noma ngesiNgisi =SUMPRODUCT(—(A2:A20<>B2:B20))
Uma umphumela unguziro, izinhlu ziyefana. Ngaphandle kwalokho, banomehluko. Ifomula kufanele ifakwe njengefomula yamalungu afanayo, okungukuthi ngemva kokufaka ifomula kuseli, ungacindezeli Faka, Futhi Ctrl + Shift + Faka.
Uma udinga ukwenza okuthile ngamaseli ahlukene, enye indlela esheshayo izokwenza: khetha womabili amakholomu bese ucindezela ukhiye F5, bese efasiteleni elivuliwe inkinobho Qinisekisa (Okukhethekile) - Umehluko wemigqa (Umehluko werowu). Ezinguqulweni zakamuva ze-Excel 2007/2010, ungasebenzisa futhi inkinobho Thola bese ukhetha (Thola futhi Khetha) – Ukukhetha iqembu lamaseli (Iya kokuthi Okukhethekile) ithebhu Ikhaya (Ikhaya)
I-Excel izogqamisa amaseli ahluka ngokuqukethwe (ngomugqa). Ngemva kwalokho zingacutshungulwa, isibonelo:
- gcwalisa ngombala noma ifomethi ngokubukeka ngandlela thize
- sula ngokhiye Susa
- gcwalisa yonke into ngesikhathi esisodwa ngenani elifanayo ngokulifaka bese ucindezela I-Ctrl + Faka
- susa yonke imigqa ngamaseli akhethiwe usebenzisa umyalo Ikhaya — Susa — Susa imigqa eshidini (Ekhaya - Susa - Susa Imigqa)
- njll
Inketho 2: Uhlu Oluxubekile
Uma izinhlu zinosayizi abahlukene futhi zingahlelwanga (izakhi zilandelana ngendlela ehlukile), kuzomele uhambe ngenye indlela.
Isixazululo esilula nesishesha kakhulu ukunika amandla ukugqanyiswa kombala komehluko usebenzisa ukufometha okunemibandela. Khetha kokubili ububanzi obunedatha bese ukhetha kuthebhu ikhaya – Ukufometha okunemibandela – Gqamisa imithetho yeselula – Amanani Ayimpinda:
Uma ukhetha inketho Ukulungisa, bese i-Excel izogqamisa okufanayo ohlwini lwethu uma inketho Ehlukile – umehluko.
Ukugqamisa umbala, nokho, akulula ngaso sonke isikhathi, ikakhulukazi kumatafula amakhulu. Futhi, uma izakhi zingaphindwa ngaphakathi kwezinhlu ngokwazo, le ndlela ngeke isebenze.
Kungenjalo, ungasebenzisa umsebenzi COUNTIF (COUNTIF) kusukela esigabeni Isitatimende, ebala ukuthi i-elementi ngayinye esohlwini lwesibili ivela kangaki kowokuqala:
Uziro owumphumela ukhombisa umehluko.
Futhi, ekugcineni, "i-aerobatics" - ungabonisa umehluko ohlwini oluhlukile. Ukuze wenze lokhu, uzodinga ukusebenzisa ifomula yamalungu afanayo:
Kubukeka kusabisa, kodwa kwenza umsebenzi ngendlela efanele 😉
- Gqamisa izimpinda ohlwini ngombala
- Ukuqhathanisa ububanzi obubili nesengezo se-PLEX
- Ukwenqatshelwa kokufaka amanani ayimpinda