Msaada wa Excell

Matata Kipepeo Jungu · Apr 24, 2023

Wakuu kwema?

Naomba msaada wa excell.

Naandaa template ya matokeo kwa shule za MSINGI.

Sheet 1 nimeweka kwaajili ya kujaza alama.

Sheet 2 nimeweka sehemu ya matokeo,yaan madaraja ya kila somo,jumla na kadhalika.

Sheet 3 Nimeweka kwaajili ya rank,yaan aanze mwenye alama kubwa kwenda ndogo

Sheet 4.....5....6....

Tatizo lipo hapo kwenye rank....nashindwa kuweka fomula ya kupanga wanafunzi kwa kuanza na mwenye alama kubwa kwenda ndogo....ifanye excell yenyewe na sio kuja kufanya manually baadae....msaada tafadhali!

mjumbe wa bwana · Apr 24, 2023

Nitarudi ila ukitaka panga kwa tani nadhani majina hayataweza kama unavyo yaingiza

mjumbe wa bwana · Apr 24, 2023

Mkuu kuna. Sheet, columns na cell
Sheet huwa ndo imebeba columns na cell
Columns huwa ndo ile mistari ya kutoka juu kuja chini
Cell ni ile mistari ya kutoka kulia kwenda kushoto

Matata Kipepeo Jungu · Apr 24, 2023

mjumbe wa bwana said:
Mkuu kuna. Sheet, columns na cell
Sheet huwa ndo imebeba columns na cell
Columns huwa ndo ile mistari ya kutoka juu kuja chini
Cell ni ile mistari ya kutoka kulia kwenda kushoto

Sijakuelewa mkuu....hivyo najua vyote.... shida yangu ni hiyo niliyoeleza hapo

Promenthous · Apr 24, 2023

Matata Kipepeo Jungu said:
Wakuu kwema?

Naomba msaada wa excell.

Naandaa template ya matokeo kwa shule za MSINGI.

Sheet 1 nimeweka kwaajili ya kujaza alama.

Sheet 2 nimeweka sehemu ya matokeo,yaan madaraja ya kila somo,jumla na kadhalika.

Sheet 3 Nimeweka kwaajili ya rank,yaan aanze mwenye alama kubwa kwenda ndogo

Sheet 4.....5....6....

Tatizo lipo hapo kwenye rank....nashindwa kuweka fomula ya kupanga wanafunzi kwa kuanza na mwenye alama kubwa kwenda ndogo....ifanye excell yenyewe na sio kuja kufanya manually baadae....msaada tafadhali!

Kwanini usisort by hiyo column yenye marks,Z to A

Superfly · Apr 24, 2023

Matata Kipepeo Jungu said:
ndogo....ifanye excell yenyewe na sio kuja kufanya manually baadae....msaada tafadhali!

Yaan unataka ukiwa una-input data, Excel inazi-process hapo hapo??

Robin20 · Apr 24, 2023

Matata Kipepeo Jungu · Apr 25, 2023

Superfly said:
Yaan unataka ukiwa una-input data, Excel inazi-process hapo hapo??

Ndiyo

enzo1988 · Apr 25, 2023

Matata Kipepeo Jungu said:
Sijakuelewa mkuu....hivyo najua vyote.... shida yangu ni hiyo niliyoeleza hapo

Matata Kipepeo Jungu said:
Sijakuelewa mkuu....hivyo najua vyote.... shida yangu ni hiyo niliyoeleza hapo

Ungekuwa unajua maana ya sheet usingeandika hiki ulicho kiandika. Jamaa amekufafanulia vizuri.

Eti sheet A nimeweka......, sheet B nimeweka ..........., sheet..... unajua unachokifanya????????? Au excel imebadilika???????

An Excel worksheet is a software program/document that collects rows and columns designed to store information in an organized manner.

Promenthous · Apr 25, 2023

Superfly said:
Yaan unataka ukiwa una-input data, Excel inazi-process hapo hapo??

Kwa case hiyo kama data ni dynamic jaribu kutumia VBA au kama una version mpya ya excel unaweza kutumia dynamic array formulas, otherwise unaweza kuweka kwenye pivot table lkn itabidi ukiadd data then refresh pivot table yako, alternatively, unaweza kutumia trick kwa kuzi rank kwanza, tumia rank.eq function thn tumia vlookup kupanga hao wanafunzi kulingana na rank

Voice of Tanzania · Apr 25, 2023

Nikupe template yangu?

Matata Kipepeo Jungu · Apr 26, 2023

enzo1988 said:
Ungekuwa unajua maana ya sheet usingeandika hiki ulicho kiandika. Jamaa amekufafanulia vizuri.

Eti sheet A nimeweka......, sheet B nimeweka ..........., sheet..... unajua unachokifanya????????? Au excel imebadilika???????

An Excel worksheet is a software program/document that collects rows and columns designed to store information in an organized manner.

Mkuu ni wapi nimeandika sheet A??

Nimekwambia NAJUA.

Sheet ni kama ukurasa kwenye workbook.

Nimeandika kuwa sheet 1....sheet 2...na kuendelea.....

Sasa hapo kipi sikijui??

mjumbe wa bwana · May 3, 2023

Mkandamiza Vishimo said:
Nikupe template yangu?

Hivi ukitaka jua jinsi Me wangapi wamefanya mtihani utatumia formula gani mfano A nimeweka jinsi na B nimeweka marks

Matata Kipepeo Jungu · May 4, 2023

mjumbe wa bwana said:
Hivi ukitaka jua jinsi Me wangapi wamefanya mtihani utatumia formula gani mfano A nimeweka jinsi na B nimeweka marks

Nakutumia namba DM tuwasiliane

Matata Kipepeo Jungu · May 4, 2023

Mkandamiza Vishimo said:
Nikupe template yangu?

Sawa,naiomba

CRYPT · May 4, 2023

Promenthous said:
Kwa case hiyo kama data ni dynamic jaribu kutumia VBA au kama una version mpya ya excel unaweza kutumia dynamic array formulas, otherwise unaweza kuweka kwenye pivot table lkn itabidi ukiadd data then refresh pivot table yako, alternatively, unaweza kutumia trick kwa kuzi rank kwanza, tumia rank.eq function thn tumia vlookup kupanga hao wanafunzi kulingana na rank

Caution kama atatumia lookup kwa kuangalia rank, ikiwa kuna wanafunzi wamelingana rank itashinwa kuwavuta wote kwenye hiyo sheet

Njuka II · May 4, 2023

CRYPT said:
Caution kama atatumia lookup kwa kuangalia rank, ikiwa kuna wanafunzi wamelingana rank itashinwa kuwavuta wote kwenye hiyo sheet

Wakilingana anachukuliwa wa kwanza, ili wasilingane ile rank value inabidi uiongezee na SN/1000 au SN/10000 ili kuipa decimal points. Mfano kama mtu wa SN 10 na wa SN 100 wana wastani wa 100, huyu wa SN 10 atakuwa na 100+10/1000=100.001 na huyu wa SN 100 atakuwa na 100+100/1000=100.1

Murashani GALACTICO · May 4, 2023

Mkandamiza Vishimo said:
Nikupe template yangu?

Mkuu naomba uni PM hiyo template yako. Msaada tafadhali.

CRYPT · May 5, 2023

Njuka II said:
Wakilingana anachukuliwa wa kwanza, ili wasilingane ile rank value inabidi uiongezee na SN/1000 au SN/10000 ili kuipa decimal points. Mfano kama mtu wa SN 10 na wa SN 100 wana wastani wa 100, huyu wa SN 10 atakuwa na 100+10/1000=100.001 na huyu wa SN 100 atakuwa na 100+100/1000=100.1

NImejifunza kitu kipya, shukran sana mkuu

k2206 · May 5, 2023

Njuka II said:
Wakilingana anachukuliwa wa kwanza, ili wasilingane ile rank value inabidi uiongezee na SN/1000 au SN/10000 ili kuipa decimal points. Mfano kama mtu wa SN 10 na wa SN 100 wana wastani wa 100, huyu wa SN 10 atakuwa na 100+10/1000=100.001 na huyu wa SN 100 atakuwa na 100+100/1000=100.1

Mtaalamu. Nakukubali sana.

Msaada wa Excell

Member

JF-Expert Member

JF-Expert Member

Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

Member

JF-Expert Member

Member

Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

Similar Discussions