Showing posts with label GoogleDoc. Show all posts
Showing posts with label GoogleDoc. Show all posts
2020/09/08

[Google Sheet] How to download Google Sheet via command line as Excel file?

›
Requirement How to download Google Sheet via command line as Excel file into specific directory? How-To In Windows: powershell -command ...
2020/09/02

[Google Sheet] How to join double quote

›
How-To Step 1. Check double quote value in ASCII Codes Table , i.e. char(34) Step 2. Then you can using char(34) as bellows: =concatenate( ...
2020/04/09

[Google Sheet] SUMPRODUCT function

›
Requirement 我想計算我所訂購的飲料總價 (i.e. I11)，有無可用的現成 function 快速算出 How-To 使用 SUMPRODUCT 此 function 可以完成此需求，此 function 有兩個參數，其會針對兩個大小相同的陣列或範圍...
2019/12/10

[Google Spreadsheet] How to realize column alias in query function

›
Here has raw data If I would like to find Apple's data, and rename column as bellows: You can use label to do alias
2019/12/08

[Google Spreadsheet] How to remove duplicate item?

›
Here has my raw data: If I would like to know all distinct item as bellow: We can make good use of unique function to remove dupli...
2019/11/10

[Google Sheet] Add-ons : Size My Sheet

›
Problem Each Google Sheet can support up to 5 million cells. If I reach its limitation, I cannot keep working on current Google Sheet. Ho...
2019/07/13

[Google Sheet] How to get the last non-empty value from a row?

›
Scenario I have a history data regarding selling quantity from January to May. Assume the latest data is April, how do I get the last non-...
2019/07/12

[Google Sheet] How to provide dynamic parameter value for where condition in query function?

›
Here has raw data If I would like to find specific fruit based on the input value: You can do this way:
2019/06/13

[Google Sheet] OpenSolver 使用範例

›
假設我有個生產決策必須決定，我要生產幾個 duck or fish 娃娃，放到娃娃機，並能讓獲利最大化。duck 與 fish 的每單位耗用橡膠量分別為 100 與 125，每單位利潤分別為 $5 與 $4 已知限制條件如下，依據歷史資料， duck 與 fish 每...
2019/06/10

[Google Spreadsheet] How to create pivot table?

›
Raw data Data => Create pivot table Configuration: * Set Fruit as row * Create multiple values, including summary, average...
2019/05/15

[Google Spreadsheet] How to realize group by function in Google Spreadsheet?

›
Assume I have the following raw data: We can make good use of query function to meet group by requirement: Check the result: ...
2019/05/13

[GoogleDoc] Using max function in conditional formatting

›
Problem Assume I have a number of row, I would like to highlight the max value. How to do it? How-To Steps are: 1. Select the range ...