A helpful prior posting provided the formula that helped me accomplish the count of a list of text values, and to find the number of just unique values. =SUMPRODUCT((C2:C14<>"")/COUNTIF(C2:C14,C2:C14&""))
This was great, but as an intermediate Excel user, I'd find it helpful if anyone could provide an verbal translation of what the formula is actually doing. I find that to be helpful in using adaptions of that same formula or operation in future worksheet situations. Anyone?
Thanks
This was great, but as an intermediate Excel user, I'd find it helpful if anyone could provide an verbal translation of what the formula is actually doing. I find that to be helpful in using adaptions of that same formula or operation in future worksheet situations. Anyone?
Thanks