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: VBA
Assigning Macros to Drop Down Lists in Excel
Assigning macros to Form Controls is easy and to Active X controls is easier because they expose themselves to a[…]
Read moreReplicating TEXTJOIN using VBA
Excel 2016 introduced the TEXTJOIN function which is a much improved version of CONCATENATE function. I always found CONCATENATE quite[…]
Read more