Samar da matsala
Akwai kewayon bayanai wanda ake maimaita wasu dabi'u fiye da sau ɗaya:
Ayyukan shine ƙidaya adadin ƙididdiga na musamman (marasa maimaituwa) a cikin kewayon. A cikin misalin da ke sama, yana da sauƙi a ga cewa zaɓuɓɓuka huɗu ne kawai aka ambata a zahiri.
Bari mu yi la'akari da hanyoyi da yawa don magance shi.
Hanyar 1. Idan babu komai a cikin sel
Idan kun tabbata cewa babu komai a cikin kewayon bayanan asali, to zaku iya amfani da gajeriyar tsari mai kyau:
Kar a manta ka shigar da shi azaman tsarin tsari, watau danna bayan shigar da dabarar ba Enter ba, amma hade Ctrl + Shift + Enter.
Ta hanyar fasaha, wannan dabarar tana ƙididdige duk sel na tsararrun kuma tana ƙididdige kowane kashi adadin abubuwan da suka faru a cikin kewayon ta amfani da aikin. COUNTIF (COUNTIF). Idan muka wakilta wannan a matsayin ƙarin shafi, to zai yi kama da haka:
Sannan ana lissafta ɓangarorin 1/Yawan abubuwan da suka faru ga kowane nau'i kuma an taƙaita su duka, wanda zai ba mu adadin abubuwan musamman:
Hanyar 2. Idan akwai sel marasa komai
Idan akwai sel mara komai a cikin kewayon, to lallai ne ku ɗan inganta dabarar ta ƙara rajista don sel mara komai (in ba haka ba za mu sami kuskuren rarraba ta 0 a cikin juzu'i):
Shi ke nan.
- Yadda ake cire abubuwa na musamman daga kewayon da cire kwafi
- Yadda ake haskaka kwafi a cikin jeri tare da launi
- Yadda ake kwatanta jeri biyu don kwafi
- Cire bayanan musamman daga tebur ta wani shafi da aka bayar ta amfani da ƙari na PLEX