Distinct Count in Excel
The most Powerful tool (arguably) in Excel …Pivot Tables… do not allow the Distinct Count of a Field …..(at least[…]
Read moreCategory: Formulas
Replicating TEXTJOIN using VBA
Excel 2016 introduced the TEXTJOIN function which is a much improved version of CONCATENATE function. I always found CONCATENATE quite[…]
Read moreUse INDIRECT to Pull Data from Different Worksheets/ Named Ranges
INDIRECT is a Powerful function in Excel. In this post I am going to show you how INDIRECT can be[…]
Read moreARRAY FORMULAS
Array formulas are powerful formulas in Excel that perform calculations using multiple ranges of cells. They are also known as[…]
Read more