Bayanin adadin Excel

Ƙarin lamarin Excel

Samun jerin dabi'un, kuma so in san sau sau kowane shigarwa ta musamman ya maimaita?

Dubi kasa da hanyoyi guda biyu don yin hakan: amfani da maɓallin pivot don ƙididdige yawan lamarin, ko ƙidaya sau nawa darajar ta bayyana a cikin shafi na Excel tare da ayyuka masu ginin.

Don wannan misali, za mu yi amfani da jerin sunayen birni, kuma a cikin Excel za mu ƙidaya sau nawa darajar ta bayyana a cikin wani shafi.

Gurbin yana ƙunshe da nau'in lambobi na sunayen birni, kamar yadda ya zo daga jerin adiresoshin, wanda muka fitar da birane. A ƙarshe, zamu iya samun adadin adireshin daga kowace birni misali, ko don sanin wane birni mafi yawan wakiltar a cikin jerin, ko kuma yana da ƙananan mazauna.

Yawan abubuwan da ke faruwa a Excel

Manufar ita ce gano samfurin da ya faru a cikin jerin, yana nuna jerin abubuwan kirki amma sau ɗaya kawai, da kuma samun fasali na Excel.

Kamar yadda aka bayyana a sama, muna da mafita biyu, wanda ya kamata a yi amfani da mahimman nauyin lissafin ƙididdigar ƙira, kuma don samun ƙididdigar Excel ta amfani da ayyuka masu mahimmanci.

Dukansu mafita zasu ba mu wannan sakamakon.

Abubuwan da ke faruwa a layi na pivot

Ga cikakkiyar bayani ga Excel ƙidaya sau nawa darajar ta bayyana a cikin wani shafi, ta amfani da tebur maɓallin pivot.

Fara da zabi jerin jerin dabi'unka, kuma je zuwa menu Fara> PivotTable:

Tabbatar cewa zaɓi ɗinka daidai ne, kuma a ƙarshe zaɓan wane takardar da kake son gilasar pivot ta ƙididdiga dabi'u mai mahimmanci da za a samar.

A nan ku ne, kuyi amfani da tebur mahimmanci don ƙididdiga dabi'u masu mahimmanci - a cikin misali na kasa tare da shafi ɗaya, wanda za'a yi amfani dashi a cikin tebur mai mahimmanci don ƙidaya yawan lamarin.

Jawo da sauke sunan wannan shafi tare da dabi'u da kake son ƙidaya zuwa ROWS.

Lambar maɓallin lissafi na layi na Pivot

Yi maimaita aiki, ja da sauke sunan sunaye zuwa VALUES don samun nau'in lissafi na Excel lissafi na musamman.

Tabbatar cewa an zaɓi Zaɓin zaɓi, kuma a nan! Ka san sau nawa kowane lambobi na musamman sun bayyana a cikin jerinka tare da lambobin adadin lambobi na Pel na Excel. Wannan shi ne yadda za a sami layuka masu la'akari da launi na pivot.

Ƙididdigar Excel

Ana iya amfani dashi don dalilai daban-daban, kamar a ƙidayar adadi na Excel a kalma yana bayyana, ko ta amfani da maɓallin pivot, ƙidaya sau nawa kowanne sunan rukuni ya bayyana a cikin jerin, kuma a cikin Excel ƙidaya sau nawa darajar ta bayyana a cikin wani shafi. Har ila yau, ya ba da tabbacin ƙididdiga a cikin tebur na Tel 2016.

Excel ƙidaya sau nawa kowace darajar ta bayyana a cikin wani shafi

Kasance mai kyau Pro: Kasance da karatunmu!

Daukaka kwarewarku daga novice ga gwarzo tare da muxin muxinmu na 365, wanda aka tsara don sanya ku ƙwarewa a cikin 'yan zaman a cikin' yan zaman.

Rijista a nan

Sauran bayani ga Excel ƙidaya sau nawa darajar ta bayyana a cikin wani shafi, don amfani da gina a ayyuka.

Fara da kwafin jeri, sa'annan ku shafe shi a wani shafi. Tare da bayanan da aka zaɓa, danna kan zaɓin menu DATA> Cire Duplicates. Wannan zai ba ka damar samun shafi guda ɗaya tare da duk dabi'u, da kuma shafi daya tare da ƙayyadaddun dabi'u kawai don ƙyale yawan adadin lambobi na Excel.

A cikin Cire Duplicates menu, ka tabbata cewa ka zabi maɓallin dama, sa'annan ka sake gano idan babu wani kai.

Dole ne a nuna saƙon sakonni, nuna yawan shigarwa da mahimmanci lambobi sun ƙunshi

Excel ƙidaya sau nawa darajar ta bayyana

Bayan haka, kusa da farkon shigarwa na ƙananan dabi'u, shigar da aikin nan, don ƙidayar sau sau da yake faruwa a cikin cikakken jerin.

Ƙididdiga ta aiki za ta yi a Excel a ƙidayar sau nawa darajar ta bayyana a cikin wani shafi. Dole a ba da shafi a matsayin gardama na farko, da kuma darajar da za a nema a matsayin gardama ta biyu.

Yadda za a ƙidaya abubuwan da ke faruwa a Excel

Duba sakamakon farko, ƙaddamar da wannan tsari zuwa duk ƙirar dabi'u don ƙidaya yawan abubuwan da ke faruwa a Excel.

Kuma wannan! A nan an nuna sakamakon, tare da yawan abubuwan da ke faruwa a Excel don kowane darajar.

Ana iya amfani dashi misali don ƙidaya yawan lokuta kalma ta bayyana a cikin Excel, don yin aukuwa na Excel ƙididdigar a cikin shafi, ko kuma ƙididdige duplicates a cikin Excel, kuma ba shakka don gano a Excel sau nawa darajar ya bayyana.

La'idar lissafi na Excel na musamman

Wata hanya ta ƙididdige abubuwan da ke faruwa a Excel, shi ne yin amfani da maɓallin keɓaɓɓiyar lissafi don ƙididdiga abubuwan da ke faruwa a cikin ɗakunan rubutu.

Don yin haka, fara da ciwon tebur a shirye a cikin ɗakunan rubutu.

Ƙirƙirar wani sabon matakan pivot ta zaɓin teburin tare da dabi'un da ake bukata, kuma, a cikin jerin filin, ja da sauke sunan wannan shafi tare da dabi'u don ƙidaya ƙira a cikin akwatin kwallin jeri, sa'annan ya ɗora da sauke wannan ginshiƙan zuwa dabi'u akwatin.

Ƙungiyar Pivot ta Excel zai nuna ƙididdigar dabi'u mai mahimmanci irin wannan hanya.

Tambayoyi Akai-Akai

Wane irin tsari ne ko aiki a Fimina za a iya amfani da shi wajen kirga abin da ya faru na takamaiman darajar ko rubutu a cikin bayanan?

Don ƙididdige abin da ya faru na takamaiman darajar bayani, an yi amfani da kewayon aiki, ana amfani da ka'idodi. Wannan aikin yana ba masu amfani damar tantance kewayon sel don bincika da kuma ka'idojin don kirga, miƙa hanya madaidaiciya hanya don ɗaukar abubuwan da aka samo asali a cikin bayanan.

Cikakken 2019 Excel ga Masu farawa a bidiyo