Tag: Spreadsheet
August 5, 2024
/ Artikel, Excel
How to replace non empty cells with specific value in Excel?
In Excel, we can quickly and easily replace or fill a selection with a specific value by pressing Ctrl + Enter keys,…
July 13, 2022
/ Uncategorized
List all Google Drive links of Files / folder to Google Sheet
Google Drive is a powerful cloud storage service provided by Google for free. We can easily add, modify, delete files…
July 13, 2022
/ Excel
Pivot Table With Text in Values Area
Can you build a pivot table with text in the values area? Susan from Melbourne Florida has a text field…
September 24, 2020
/ Uncategorized
CARA MENDAPATKAN LIST FILE DI GOOGLE DRIVE MENGGUNAKAN GOOGLE SCRIPT
function myFunction() { var ss=SpreadsheetApp.getActiveSpreadsheet(); var s=ss.getActiveSheet(); var c=s.getActiveCell(); var fldr=DriveApp.getFolderById(“paste link google drive disini hanya barisan angka dan nomor”);…