Wakuu nisaidieni formula hii ya Excel

[sky soldier]

 

[sky soldier]

kitu pasua kichwa hii, na mimi nimehangaika saa zima asee

 

[Baba wa Mapaka]

View attachment 1826924


View attachment 1826922

Lete nikusaidie mkuu unatakaje?

 

[sky soldier]

Lete nikusaidie mkuu unatakaje?

nsaidie formula mkuu,

 

[intelinside]

Hakuna formula bro,

Table yako inatakiwa iwe na columns za kidato na jina
Mfano

Kidato. Jina
1. Amina
1. Asha
3. Asia
2. Juma
2. Ali
1. Hamis



Then unatumia pivot table mchezo umeisha...

 

[sky soldier]

Hakuna formula bro,

Table yako inatakiwa iwe na columns za kidato na jina
Mfano

Kidato. Jina
1. Amina
1. Asha
3. Asia
2. Juma
2. Ali
1. Hamis



Then unatumia pivot table mchezo umeisha...

cheki kazi hii, mfano nataka ku filter comments zenye likes nyingi, nikizifilter replies sizioni yani

 

[intelinside]

Bro mbona rahisi sana na iko straight forward!, Kama unataka ku filter likes nyingi let's say laikes zaidi ya 5, you jut customize the filer kwenye filed ta likes iwe grater than 5 basi, table yote itakaua yenyr comments zenye likes zaidi ya 5...

 

[dronedrake]

Njuka II

 

[sky soldier]

Bro mbona rahisi sana na iko straight forward!, Kama unataka ku filter likes nyingi let's say laikes zaidi ya 5, you jut customize the filer kwenye filed ta likes iwe grater than 5 basi, table yote itakaua yenyr comments zenye likes zaidi ya 5...

Nimeshindwa ndio mana nmeweka faili mkuu, naomba unisaidie then uweke hilo file humu

Njuka II

Toa mchango acha porojo

 

[dronedrake]

Toa mchango acha porojo

niache porojo tena, nimetag jamaa mweye ujuzi wa iyo mambo, mimi ni kilaza

 

[sky soldier]

Chief-Mkwawa Njunwa Wamavoko Mwl.RCT

 

[intelinside]

Cheki hilo, liko filtered with greater than 30 comments, note nimetumia WPS Office ya simu, ukifungua kwenye MS Excel itaonyesha piaView attachment lissa rapcha comments filtered greater than 30.xlsx

 

[intelinside]

View attachment lissa rapcha comments filtered greater than 30.xlsx

 

[sky soldier]

Cheki hilo, liko filtered with greater than 30 comments, note nimetumia WPS Office ya simu, ukifungua kwenye MS Excel itaonyesha piaView attachment 1827637

Mkuu huko kote nmejaribu, Naona file lako lina shida ile ile tu kama niliyoleta

 

[intelinside]

Mkuu huko kote nmejaribu, Naona file lako lina shida ile ile tu kama niliyoleta

View attachment 1827709

Mdau, sidhani kama kuna formula ya filtration, ila ukiangalia file lako lako hapa kwa umakini, nadhani unachokitaka ni hiki

View attachment lissa rapcha comments based on replies.xlsx

 

[intelinside]

Hapo hapo kigezo ni replies, sasa si kila comments zenye likes nyingi zina replies, hivyo ukitaka kigezo cha likes unaweza kuongeza hiyo criteria kwenye likes, ili uone

 

[sky soldier]

Mdau, sidhani kama kuna formula ya filtration

Hapo hapo kigezo ni replies, sasa si kila comments zenye likes nyingi zina replies, hivyo ukitaka kigezo cha likes unaweza kuongeza hiyo criteria kwenye likes, ili uone

Mkuu, asante angalau umejitahidi , ilibidi niulize kwa wa hindi naona wamenipa formula na inafanya kazi fresh

kwenye E2 unaweka hii formula =IF(D2="",E1-1,D2*100) ,

 

[uzewela]

Concatenate,itakubali