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 moreThe most Powerful tool (arguably) in Excel …Pivot Tables… do not allow the Distinct Count of a Field …..(at least[…]
Read moreAssigning macros to Form Controls is easy and to Active X controls is easier because they expose themselves to a[…]
Read moreExcel 2016 introduced the TEXTJOIN function which is a much improved version of CONCATENATE function. I always found CONCATENATE quite[…]
Read more