How to Get Unique Values Without Unique function?
December 23, 2020
I will show you how to get unique values without unique function, by a standard formula or an array formula. Here is the perfect substitute for Unique.
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
Perform Left/Mid On Array Formula (Excel)
November 25, 2020
LEFT, MID, RIGHT are some of the most useful text function in Excel. They allow us to extract a specified number of characters from a text string. Yet, normal LEFT, MID, RIGHT only work in a single cell. To perform
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)
