Another easy one

Mar 7th, 2002, 11:25 PM

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 · Mar 7th, 2002, 11:31 PM

Quote:

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)))

Mar 7th, 2002, 11:36 PM

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??

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 11:25 PM	#1
Guest Posts: n/a	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

Mar 7th, 2002, 11:36 PM	#3
Guest Posts: n/a	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??