ExcelExcel macro that automatically generates a pattern list of combinations
How to Auto Generate Combinations in Excel VBA Macro This article will show you how to auto generate a combination of di...
Excel
Excel ExcelWhat is “exponential” in Excel’s display format?
When you select "Exponential" as the Excel display format, the numbers in that cell are displayed in scientific notation...
ExcelWhen I enter a number with brackets in Excel, it is converted to a minus sign.
In accordance with common accounting practice, Excel displays negative numbers in parentheses. Thus, if you enter a numb...
Excel VBA MacroIt only takes one shot! How to bulk replace destination addresses of hyperlinks in Excel workbook
It only takes one shot! How to bulk replace destination addresses of hyperlinks in Excel workbook If you want to replace...
ExcelTo print at the maximum size that fits on one page
In Excel, I will introduce how to print a worksheet as enlarged as possible. It is a procedure to expand as long as it d...
ExcelCount specific characters “other than” with COUNTIF function
COUNTIF function Learn how to count non-specific characters with the COUNTIF function. The format of the COUNTIF functio...
ExcelCount specific characters “other than” with COUNTIF function
COUNTIF function Learn how to count non-specific characters with the COUNTIF function. The format of the COUNTIF functio...
ExcelUse “none” inside an IF function
Basic form of the IF function If the in column A is "○" when it is "star", and if it is "×" otherwise, use the IF functi...