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

[nooby]

Condition format wala thiyenawa duplicate option ekak eken wade karaganin

eka hariyanne ne bn. meka eeta wada tiakak complex wedak

 

[ManjuT]

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.

Sheets echchara godak thiyenawanam wede amarui thamai. Data tika sql db ekakata dagena query ekakin karaganna puluwan wei neda.

 

[tsomeone]

VLOOKUP function eka thama use karanna one net eken balanna dana hati

 

[nooby]

Sheets echchara godak thiyenawanam wede amarui thamai. Data tika sql db ekakata dagena query ekakin karaganna puluwan wei neda.

karana widiha poddak kiyapnko. or link plz

 

[willpower]

Bump

 

[ManjuT]

karana widiha poddak kiyapnko. or link plz

Excel to MySQL;
https://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-export.html

Install MySQL Workbench
https://dev.mysql.com/doc/workbench/en/

SQL Query eka liyaganna puluwan neda? meketh poddak balanna.
https://www.w3schools.com/sql/sql_syntax.asp

mama hithanawa meken karaganna puluwan wei kiyala

 

[nooby]

Excel to MySQL;
https://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-export.html

Install MySQL Workbench
https://dev.mysql.com/doc/workbench/en/

SQL Query eka liyaganna puluwan neda? meketh poddak balanna.
https://www.w3schools.com/sql/sql_syntax.asp

mama hithanawa meken karaganna puluwan wei kiyala

thanks machn. mama sql use karalama ne. try ejak deela balala kiyannamko.

 

[nooby]

rep ++ for all