ප්‍රෝග්‍රෑම් වැඩ්ඩන්ගේ අවධානය පිණිසයි

[nooby]

ප්‍රෝග්‍රෑම් වැඩ්ඩන්ගේ අවධානය පිණිසයි

මචන් පොඩි උදව්වක් ඕනේ. මගේ ලග excel sheet එකක (පහල දාල තියෙනේ ) තියෙන D කෝලම් එකේ එකම දේ දෙපාරක් හෝ ඊට වැඩි වතාවක් ඇවිත් නම් D කෝලම් එකත් එක්කම ඒකට අදාල F කෝලම් එකේ ඒවා පෙන්නන විදිහට හදාගන්න තමා ඕනේ.

[/IMG]

 

[HKavinda]

බම්පි​

 

[kkroxc]

uba huawei ekeda?

 

[Aruna119]

bump​

 

[mtmadushanka]

 

[Jolly_Roger]

Programming ekka thiyana sambande poddak kiyapanko ? ubata meka DB ekata import karalada oya wade karaganna ona ?

 

[nooby]

uba huawei ekeda?

ne bn. ubath me field ekeda inne

 

[nooby]

rep add for all

 

[ManjuT]

Advance filter option eka use karala karanna beluwada?

 

[nooby]

Programming ekka thiyana sambande poddak kiyapanko ? ubata meka DB ekata import karalada oya wade karaganna ona ?

ow bn ehema karana eka neda lesi?? nettam macro walinuth puluwan neda excel athulema karaganna.

kohoma unath kamak ne wede karagannai one

 

[nooby]

Advance filter option eka use karala karanna beluwada?

ne bn, kohomada eka use karanne

 

[smart_dx]

IMAGE 1 පෙන්නේ නෑ

 

[nooby]

IMAGE 1 පෙන්නේ නෑ

welawakata ohoma thama bn. me link eken balapnko, rep++

http://i66.tinypic.com/14uc4nr.jpg

 

[rambolala]

How about remove duplicate option in excel ?

 

[nooby]

How about remove duplicate option in excel ?

that doesnt work. i'm specially focusing on duplicated items, ++

 

[rambolala]

that doesnt work. i'm specially focusing on duplicated items, ++

so you want to extract duplicate items ?
try this
https://www.accountingweb.com/technology/excel/identifying-duplicate-values-in-an-excel-list

 

[nooby]

so you want to extract duplicate items ?
try this
https://www.accountingweb.com/technology/excel/identifying-duplicate-values-in-an-excel-list

try kara bn. eth meka hari yanne ne

 

[ManjuT]

ne bn, kohomada eka use karanne

https://www.ablebits.com/office-addins-blog/2016/09/07/excel-advanced-filter/

meke criteria range ekata oyage condition eka denna one. e kiyanne d columns eke count eka 1 ta wedi ewa select karanna kiyala. ekata wenama column ekakata counts tika ganna weida danne. nethnam eka seretama denna puluwan kiyala balanna one.

mamath awurudu ganakin use kare ne. den advance filter option eka thawath advance ethi. wenna one wede mama therum gaththa widiyatanam meken karanna puluwan.

 

[wolvoring]

Condition format wala thiyenawa duplicate option ekak eken wade karaganin

 

[nooby]

https://www.ablebits.com/office-addins-blog/2016/09/07/excel-advanced-filter/

meke criteria range ekata oyage condition eka denna one. e kiyanne d columns eke count eka 1 ta wedi ewa select karanna kiyala. ekata wenama column ekakata counts tika ganna weida danne. nethnam eka seretama denna puluwan kiyala balanna one.

mamath awurudu ganakin use kare ne. den advance filter option eka thawath advance ethi. wenna one wede mama therum gaththa widiyatanam meken karanna puluwan.

ekin eka mewa karanna be bn. cells dahakata wada thiyenawa. a wage sheets bara ganak tyenawa.

excel data tika import karala ethanin duplicates tika and correspondings values in F column ganna widihak nedda bn. python wage use karala.