Excel Udawwak oni.....

[tcpik]

excel wala list ekaka rows kiyak thiyenawada balanna yata count kiyala box ekak awith pennuwa dan eka nane eka aye ganne kohomada ???

 

[*danushka*]

excel wala list ekaka rows kiyak thiyenawada balanna yata count kiyala box ekak awith pennuwa dan eka nane eka aye ganne kohomada ???

machan formula eka delete wenna athi.. me formula eka dala balanna.range eka oyage data list eke rage ekata wenas karaganna.mama udaharayak vidiyata data range eka column "A" eke row 1 indan 10 wenakan thiyenawa kiyala hithala thamai meka danne.oya eka wenas karaganna..

=COUNTA(A1:A10)

 

[sanoka]

ethana right click karala CountA kiyana eka select karanna

 

[tcpik]

machan formula eka delete wenna athi.. me formula eka dala balanna.range eka oyage data list eke rage ekata wenas karaganna.mama udaharayak vidiyata data range eka column "A" eke row 1 indan 10 wenakan thiyenawa kiyala hithala thamai meka danne.oya eka wenas karaganna..

=COUNTA(A1:A10)

mama danne na ban meka danna. giya para mokak hari jalbariyak karala dagaththe dan mathaka nane. eka thiyeddi mama data ekak gahala filter ekak dammath e ena list eke count eka max min kiyala list ekak awa list eka yatin eke count dunnama rows gana pennuwa.

 

[tcpik]

ane kawruth nadda..... ???

 

[Pink panther]

=counta(ube rows tika select karapan )

 

[*danushka*]

ane kawruth nadda..... ???

machan puluwannam TeamViewer daganin mama avilla oyage wade karala dennam.loku deyak na karanna.. wena wisadumak nam mata penne na..

 

[Łűɱíņã™]

 

[tcpik]

machan puluwannam TeamViewer daganin mama avilla oyage wade karala dennam.loku deyak na karanna.. wena wisadumak nam mata penne na..

mama team viewer ennam machan.

 

[dilrasan]

machan...Excel sheet eke task bar (yatama thiyena eke..ekiwwe oya oya kiyana place eke thama...nama harida danne nehe) right click kalama list ekak enawa...eke ethi count kiyala...anna eka select kalama hari....

right hand side eken wetenawa count kiyala...

 

[tcpik]

thanks all wade hari *danushka* brother team viewer awith wade goda dala dunna.

 

[tcpik]

machan...Excel sheet eke task bar (yatama thiyena eke..ekiwwe oya oya kiyana place eke thama...nama harida danne nehe) right click kalama list ekak enawa...eke ethi count kiyala...anna eka select kalama hari....

right hand side eken wetenawa count kiyala...

thanks machan......

 

[dilshanmad]

pennapu thana right click karala count kiyana ekata tick eka danna

 

[tsomeone]

 

[*danushka*]

machan oyage example eka hari, ath meyata athatama ona wela thibbe data filter kalata passe a filter una data wala count eka bala ganna.athakota apita counta formula eka use kalata hariyanne na. me pahala thiyana formula eka thamai mama wadeta use kale..

=SUBTOTAL(3,C1:C156)