Excel Macro (VBA) How to Find the Last Row in Excel Using VBA (Macro Guide for Beginners)
We show you how to search through the data from the top down, and how to start from the bottom row of the Excel file and work your way up.
Excel Macro (VBA) 
Excel Functions How to display time in 15-minute increments (CEILING and FLOOR functions) Excel
In the last issue, we introduced how to use the TIME function to display the time in 15-minute increments, 30-minute increments, etc. (TIME function) Excel pointed out that it would be easier to use the CEILING and FLOOR functions...
Excel Functions What does the error message "#VALUE!" mean and what can I do about it?
Error messages are unavoidable when dealing with Excel, and you may be surprised when they suddenly appear. Here are the meanings and countermeasures for these errors. As an example of preconditions, let's make a table like this...
Excel Functions How to extract characters before a specific character "LEFT and FIND functions in Excel"
As shown in the figure below, if there is extra data after the string and you want to extract only the string to the left of the extra data, you cannot simply use the LEFT function alone because the number of characters is not constant. Function to extract the left side of the "¥" mark in cell "A2" = LEFT(A2,FIND(...))
Excel Functions Auto-filter cuts out in the middle, how to fix Excel (Excel)
Have you ever had a situation where you applied an auto-filter and found that the auto-filter was only working on the 20th row, even though data was included up to the 100th row? In this article, we will introduce what you should check when you encounter such a situation. Auto filter aperture...
Excel Functions SUMIF and SUMIFS Functions Excel
The SUMIF function can be used to change the contents of the total according to conditions, and the SUMIFS function can be used to specify multiple conditions. The reason why and how to use the SUMIF...
Excel Functions Top 4 Ways to Write Vertically in Excel: Features, Pros, and Best Use Cases
Excel is normally designed to be written horizontally, but it can also be written vertically. There are several ways to do this, but in this article, we will introduce four methods, two using "cell formatting" and two using "text boxes. Using "Vertical Writing" Cell Formatting1....
Excel Macro (VBA) Excel Macro (VBA): How to use the CountIfs function in VBA!
If you are a beginner who wants to use Excel's COUNTIFS function in VBA, this is a must. This article provides a thorough explanation from basic writing to error handling. In fact, with a few tricks, you can reduce processing time from a few minutes to a few seconds. Read this article and you will be able to efficiently tabulate data from tomorrow.
Excel Functions How to correct "###" in cell display Excel (Excel)
When dealing with numbers in Excel, it often happens that the sharpness of the numbers becomes "######" as shown in the title, and the value becomes unreadable. The conclusion is that the reason for the "#####" is that the length of the value is larger than the size of the cell, making it impossible to display...
googlesheet 2 Easy Ways to Hide or Show Zero Values in Google Sheets
Looking to hide zero values in Google Sheets? This must-read guide explains two easy methods—using custom formatting and the IF function. Discover how to instantly clean up your tables and boost the visual quality of your documents. Would you like a slightly shorter or more technical variation as well?
English 
日本語