Una Tsarin tsari na Excel yana yin lissafin ƙididdiga da yawa akan saiti ɗaya ko fiye na ƙima kuma ya dawo da sakamako ɗaya ko fiye.
Bari mu ga shi da misali:
Bari mu ce kuna aiki a cikin maƙunsar bayanai a hannun dama kuma kuna son amfani da aikin transpose na Excel don kwafi abubuwan da ke cikin sel B1:B3 zuwa sel A5:C5.
Idan ka buga aikin kawai
=TRASPOSE( B1:B3 )
a cikin sel A5: C5 (kamar yadda aka nuna a ƙasa), zaku sami darajar Excel #VALORE!
saƙon kuskure, saboda a wannan yanayin sel suna aiki da kansu don haka aikin ba ya da ma'ana ga kowane tantanin halitta.
Don fahimtar aikin Transpose, muna buƙatar yin sel A5:C5
aiki tare a matsayin ARRAY. Don haka dole ne mu shigar da aikin a matsayin dabarar tsararrun Excel.
Ana shigar da tsarin tsarawa ta latsa haɗin maɓalli Ctrl + Shift + Enter
.
Kuna iya ganin cewa an shigar da dabara a matsayin dabarar tsararru, kamar yadda Excel ke sanya takalmin gyaran kafa a kusa da dabara kamar yadda aka nuna a ma'aunin dabarar maƙunsar sakamakon da ke sama.
Don a yi la'akari da tsarin tsararru, dole ne a shigar da dabara kamar haka:
Ctrl + Shift + Enter
.Za ku lura cewa Excel ta atomatik yana sanya takalmin gyaran kafa {} a kusa da tsarin tsararru. Lura cewa waɗannan dole ne a saka ta Excel, ta bin matakan da aka bayyana a sama.
Idan kuna ƙoƙarin buga takalmin gyaran kafa da kanku, Excel ba zai fassara dabarar a matsayin dabarar tsararru ba.
Excel ba zai ƙyale ka ka gyara ɓangaren kewayon sel waɗanda ke ɗauke da tsarin tsararru ba, tunda sel duk suna aiki tare azaman rukuni.
Don haka, don gyara dabarar tsararrun Excel, kuna buƙatar:
Bugu da ƙari, Excel ba zai ƙyale ku share wani ɓangare na tsarin tsararrun Excel ba. Kuna buƙatar share dabarar daga duk sel ɗin da ta mamaye.
Don haka, idan kuna son cire tsarin tsararru daga kewayon sel, kuna buƙatar haskaka dukkan kewayon sel, sannan danna maɓallin. Del
.
Yi tunanin cewa kuna aiki akan maƙunsar misalan da ke ƙasa kuma kuna son ninka kowane ƙimar a cikin sel. A1: A5
tare da daidaitattun dabi'u a cikin sel B1: B5
, sannan ƙara duk waɗannan dabi'u.
Hanya ɗaya don cim ma wannan aikin ita ce amfani da dabarar tsararru:
=SUM( A1:A5 * B1:B5 )
Ana nuna wannan a cikin ma'aunin dabarar maƙunsar sakamakon da ke ƙasa.
Lura cewa duk da cewa tsarin tsararru a cikin maƙunsar bayanan da ke sama ana shigar da shi cikin tantanin halitta ɗaya kawai, har yanzu kuna buƙatar shigar da dabarar ta amfani da Ctrl+Shift+Enter don Excel don fassara shi azaman tsarin tsararru.
Ercole Palmeri
Coveware ta Veeam zai ci gaba da ba da sabis na amsa abin da ya faru ta hanyar intanet. Coveware zai ba da damar bincikar bincike da damar gyarawa…
Kulawa da tsinkaya yana kawo sauyi a fannin mai & iskar gas, tare da sabbin hanyoyin kula da tsirrai.…
Hukumar CMA ta Burtaniya ta ba da gargadi game da halayen Big Tech a cikin kasuwar bayanan sirri. Akwai…
Dokar "Green Houses" da Tarayyar Turai ta tsara don inganta ingantaccen makamashi na gine-gine, ta kammala aikinta na majalisar tare da…