Count unique values in dinamic table

  • Thread starter Thread starter =?iso-8859-1?Q?Andr=E9s?=
  • Start date Start date
?

=?iso-8859-1?Q?Andr=E9s?=

Hi everyone:
I'm looking for a way to make a dinamic table to count
unique values.
For example, if I have:
PETER
PETER
PETER
MARY
MARY

These are 5 records, but only 2 people.
If there's a way, please tell me how.
Thank you very much
 
Hi
try:
=SUMPRODUCT((A1:A20<>"")/(COUNTIF(A1:A20,A1:A20)+(A1:A20="")))
 
=sum(1/countif(range,range))
"range" is the name of the area with your last or first name ...
validate with CTRL MAJ ENTER


--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting rows that contain any one item listed in another row 2
REPORTING unique values 26
How to count unique values? 5
Count Records 11
Using (SUM(IF(FREQUENCY....to determine unique values 2
Formula to count the number of unique dates 7
Count Unique Values 4
multiple criteria count formula with duplicate data 10

Back
Top