{"id":103,"date":"2012-04-05T04:13:03","date_gmt":"2012-04-05T04:13:03","guid":{"rendered":"http:\/\/clay2x.wordpress.com\/?page_id=103"},"modified":"2012-04-05T04:13:03","modified_gmt":"2012-04-05T04:13:03","slug":"programmings","status":"publish","type":"page","link":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/","title":{"rendered":"Programmings"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":0,"parent":18,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-103","page","type-page","status-publish","hentry"],"jetpack-related-posts":[{"id":1161,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/google-script\/","url_meta":{"origin":103,"position":0},"title":"Google Script","author":"clay","date":"February 24, 2016","format":false,"excerpt":"Script Editor","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1094,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/softwares\/","url_meta":{"origin":103,"position":1},"title":"Softwares","author":"clay","date":"August 24, 2015","format":false,"excerpt":"Back on Track by Roxio: to restore previous working OS Audacity: to record audio files","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":105,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/excel\/","url_meta":{"origin":103,"position":2},"title":"Excel","author":"clay","date":"April 5, 2012","format":false,"excerpt":"1. Countifs with multiple criteria in single criteria range =SUM(COUNTIF(M1:M12,{\"A\",\"B\",\"C\"})) =SUM(COUNTIFS(M1:M12,{\"A\",\"B\",\"C\"},B1:B12,{\"D\",\"E\",\"F\")) \u00a0","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1165,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/google-script\/how-to-write-to-a-column-cell\/","url_meta":{"origin":103,"position":3},"title":"How to Write to A Cell of Last Row","author":"clay","date":"February 24, 2016","format":false,"excerpt":"function fillCols() { var lastRow = SpreadsheetApp.getActiveSpreadsheet().getLastRow(); SpreadsheetApp.getActiveSheet().getRange('V'+lastRow).setValue('English'); }","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1163,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/google-script\/how-to-add-command-button\/","url_meta":{"origin":103,"position":4},"title":"How to Add Command Button","author":"clay","date":"February 24, 2016","format":false,"excerpt":"\/** * Adds a custom menu to the active spreadsheet, containing a single menu item * for invoking the readRows() function specified above. * The onOpen() function, when defined, is automatically invoked whenever the * spreadsheet is opened. * For more information on using the Spreadsheet API, see * https:\/\/developers.google.com\/apps-script\/service_spreadsheet\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":111,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/mysql\/","url_meta":{"origin":103,"position":5},"title":"MYSQL","author":"clay","date":"April 5, 2012","format":false,"excerpt":"Note: All these based on MySQL 5.1.61 1.\u00a0Find duplicate entries in table SELECT COUNT(*), column1, column2 FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1; 1b. List Down all the duplicate entries SELECT userid, users.user_ic, useremail, company FROM `users` INNER JOIN (SELECT useric FROM users WHERE useric <> \"\" GROUP BY\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/comments?post=103"}],"version-history":[{"count":0,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/103\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/18"}],"wp:attachment":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/media?parent=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}