How to Enable Developer tab in Excel?
December 23, 2020
In this article, I will show you one of the VBA 101 skills – enabling Developer tab. With Develop tab, you get access to a bunch of new commands that allows you to work with VBA.
Read More »
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.
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)
