ExcelExcel 365進化中！Excel 2024以降に追加された注目の新関数(2025年５月現在)
Microsoft 365版のExcel（以下、Excel 365）は、買い切り型のExcel 2024（永続ライセンス版）のリリース後も、進化を止めることなく新しい関数が次々と追加されています。これらの新機能は、基本的にExcel 365...
Excel
Excel
ExcelExcel macro that automatically generates a pattern list of combinations
How to Auto Generate Combinations in Excel VBA MacroThis article will show you how to auto generate a combination of dif...
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 workbookIf 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 do...
ExcelCount specific characters “other than” with COUNTIF function
COUNTIF functionLearn how to count non-specific characters with the COUNTIF function.The format of the COUNTIF function ...
ExcelCount specific characters “other than” with COUNTIF function
COUNTIF functionLearn how to count non-specific characters with the COUNTIF function.The format of the COUNTIF function ...
ExcelUse “none” inside an IF function
Basic form of the IF functionIf the in column A is "○" when it is "star", and if it is "×" otherwise, use the IF functio...