GoogleSpreadSheet

Counting the number of days in a month by combining the DAY and EOMONTH functions (spreadsheet)

To count the days of a month using a combination of functionsDAYinGoogle Sheets , follow these steps:EOMONTHtable of con...

2024.02.27

GoogleSpreadSheet

[FILTER function] How to perform a “fuzzy search” in combination with the FIND function (Google Spreadsheet)

This is a method for fuzzy search (extraction) with the FILTER function. What is the FILTER function? You can use the FI...

2022.10.27

GoogleSpreadSheet

Google Spreadsheet Compound Interest Calculation｜How to perform compound interest calculations (simple version)

In this article, we will introduce compound interest and compound interest calculations. What is compound interest? Comp...

2022.10.21

GoogleSpreadSheet

Google Spreadsheet What is the maximum number of rows? Verification of the maximum number of rows

Maximum number of rows in a Google Spreadsheet workbook How far can the maximum number of rows in a Google Spreadsheet w...

2022.10.20

GoogleSpreadSheet

Google Spreadsheet How to display sheet names by cell reference [Can also be used in Excel] INDIRECT function

You may often refer to data from other sheets in Google Spreadsheet or Excel. In such cases, here is how to reference th...

2022.10.19

GoogleSpreadSheet

[Google Spreadsheet] Create parade charts and ABC analysis graphs from tables | Priority analysis

What is ABC Analysis? "ABC analysis" is the idea that "the top 20% of sales account for 80% of the total", and is used w...

2022.10.18

GoogleSpreadSheet

[Google Spreadsheet] QUERY function | Query list/Summary

List of APIs that can be used with the QUERY function So far, we have practiced how to use and apply the QUERY function....

2022.10.15

GoogleSpreadSheet

[Google Spreadsheet] QUERY function | Query list Part 2 (WHERE clause)

You can extract data from a range with the QUERY function The QUERY function "uses the query language of the Google Visu...

2022.10.14

GoogleSpreadSheet

[Google Spreadsheet] QUERY function | Query list Part 1 (SELECT clause)

You can extract data from a range with the QUERY function The QUERY function "uses the query language of the Google Visu...

2022.10.13

GoogleSpreadSheet

CONCAT function”, “CONCATENATE function”, “TEXTJOIN function” functions to combine strings [Spreadsheet].

When you want to join cell data of columns and rows in Google Spreadsheet, you can use "& (Ambasand)" to join them, but ...

2022.10.10

GoogleSpreadSheet

GoogleSpreadSheet

Counting the number of days in a month by combining the DAY and EOMONTH functions (spreadsheet)

[FILTER function] How to perform a “fuzzy search” in combination with the FIND function (Google Spreadsheet)

Google Spreadsheet Compound Interest Calculation｜How to perform compound interest calculations (simple version)

Google Spreadsheet What is the maximum number of rows? Verification of the maximum number of rows

Google Spreadsheet How to display sheet names by cell reference [Can also be used in Excel] INDIRECT function

[Google Spreadsheet] Create parade charts and ABC analysis graphs from tables | Priority analysis

[Google Spreadsheet] QUERY function | Query list/Summary

[Google Spreadsheet] QUERY function | Query list Part 2 (WHERE clause)

[Google Spreadsheet] QUERY function | Query list Part 1 (SELECT clause)￼￼

CONCAT function”, “CONCATENATE function”, “TEXTJOIN function” functions to combine strings [Spreadsheet].

[Google Spreadsheet] QUERY function | Query list Part 1 (SELECT clause)