Another easy one

[Guest]

Hi guys
How do I use a D function to get number of unique items.. I'll illustrate below
Name
AAA
AAA
BBB
BBB
CCC

So the DCOUNTA formula returns 3

 

[Aladin Akyurek]

On 2002-03-07 22:25, Anonymous wrote:
Hi guys
How do I use a D function to get number of unique items.. I'll illustrate below
Name
AAA
AAA
BBB
BBB
CCC

So the DCOUNTA formula returns 3

You could appy Advanced Filter to your data and apply COUNTA to the filtered list.

A formula-based approach would be:

=IF(LEN(A2:A6),SUMPRODUCT(1/(COUNTIF(A2:A6,A2:A6)))

 

[Guest]

Well, I am planning to write the formulas using VBA, because I will need to write it for 20 sheets, everyday. Any good method to do this??