Look Up the Last Value in Column/Row in Excel
December 17, 2020
Very often we have to find out the last value in a column or in a row. When there are so many ways available in the internet, they all have a common issue – too long and complicated. If the
How to Name Multiple Single Cells in Excel?
December 12, 2020
Background Named range is a very useful feature in Excel. With Named range, the formula is more dynamic and looks a lot more descriptive. However, naming range itself can be a painful process. Naming 50 ranges manually can take you
How to Display the Formula as Text in Excel?
December 12, 2020
Background If you click into this article, you must be looking for a way to solve the below problems. How to get the formula displayed as text in Excel? How to display formula rather than result in Excel? How to
How to Get the First day of Next Month?
December 11, 2020
Background In this article, I will show you How to Get the First day of Next Month? How to find First day of Next Month? How to find 1st day of Next Month? Sample Workbook Download the workbook to practice
How to Check/Test if Sheets Exist in Excel?
December 11, 2020
Background Sometimes we would like to check if sheets exist in Excel. This is easy when you only have a few worksheets. However, if you have hundreds of sheet, it is not as easy. Even if you have the time
How to Count Cells that do not Contain Errors in Excel
December 7, 2020
Background Sometimes you may want to know the number of cells does not contain errors in your workbook. Indeed this it not difficult at all. You can accomplish it with just one simple formula. In this article, I will show
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
