Aiki na yau da kullun wanda ke tasowa a gaban kowane mai amfani da Excel shine kwatanta jeri biyu tare da bayanai kuma nemo bambance-bambance a tsakanin su. Hanyar mafita, a cikin wannan yanayin, an ƙaddara ta nau'in bayanan farko.
Zabin 1. Lissafi masu aiki tare
Idan lissafin suna aiki tare (an tsara su), to, duk abin da aka yi shi ne kawai a sauƙaƙe, saboda yana da mahimmanci, a gaskiya, don kwatanta dabi'u a cikin sel kusa da kowane jere. A matsayin mafi sauƙi zaɓi, muna amfani da dabara don kwatanta dabi'u, wanda ke samar da ƙimar boolean a fitarwa. GASKIYA (GASKIYA) or KARYA (KARYA):
Ana iya ƙididdige adadin rashin daidaituwa ta hanyar dabara:
= KYAUTA (— (A2: A20<>B2:B20))
ko a Turanci = SUMPRODUCT (—( A2: A20<>B2: B20))
Idan sakamakon ya kasance sifili, lissafin iri ɗaya ne. In ba haka ba, suna da bambance-bambance. Dole ne a shigar da dabarar azaman dabarar tsararru, watau bayan shigar da dabarar a cikin tantanin halitta, kar a latsa Shigar, Kuma Ctrl + Shigar + Shigar.
Idan kana buƙatar yin wani abu tare da sel daban-daban, to, wata hanya mai sauri za ta yi: zaɓi duka ginshiƙai kuma danna maɓallin F5, sa'an nan a cikin bude taga button haskaka (Na musamman) - Bambance-bambancen layi (Bambancin layi). A cikin sabbin sigogin Excel 2007/2010, zaku iya amfani da maɓallin Nemo ka zavi (Nemo & Zaɓi) – Zaɓin ƙungiyar sel (Je zuwa Special) tab Gida (Gida)
Excel zai haskaka sel waɗanda suka bambanta cikin abun ciki (ta jere). Ana iya sarrafa su, misali:
- cika da launi ko ta yaya na gani
- bayyana tare da maɓalli share
- cika komai lokaci guda tare da darajar iri ɗaya ta shigar da shi kuma danna Ctrl + Shigar
- share duk layuka tare da zaɓaɓɓun sel ta amfani da umarnin Gida - Share - Share layuka daga takarda (Gida - Share - Share Layuka)
- da dai sauransu.
Zabin 2: Listocin da aka Shuffled
Idan lissafin suna da girma dabam dabam kuma ba a jera su ba (abubuwan suna cikin tsari daban-daban), to dole ne ku bi ta wata hanya.
Mafi sauƙi kuma mafi sauri mafita shine don ba da damar nuna launi na bambance-bambance ta amfani da tsarin yanayi. Zaɓi jeri biyu tare da bayanai kuma zaɓi akan shafin gida – Tsarin yanayi – Haskaka ka’idojin tantanin halitta – Kwafin Dabi’u:
Idan kun zaɓi zaɓi Maimaituwa, to Excel zai haskaka matches a cikin jerin mu idan zaɓin Musamman – bambance-bambance.
Hasken launi, duk da haka, ba koyaushe dace ba, musamman ga manyan tebur. Hakanan, idan ana iya maimaita abubuwa a cikin lissafin kansu, to wannan hanyar ba zata yi aiki ba.
A madadin, zaku iya amfani da aikin COUNTIF (COUNTIF) daga category Bayanan lissafi, wanda ya ƙidaya sau nawa kowane kashi daga jeri na biyu ya faru a cikin na farko:
Sakamakon sifili yana nuna bambance-bambance.
Kuma, a ƙarshe, "aerobatics" - zaka iya nuna bambance-bambance a cikin jerin daban. Don yin wannan, kuna buƙatar amfani da tsarin tsararru:
Ga alama ban tsoro, amma yana yin aikin daidai 😉
- Hana kwafi a cikin jeri tare da launi
- Kwatanta jeri biyu tare da ƙari na PLEX
- Hana shigar da dabi'u kwafi