count unique

  • Thread starter Thread starter brendon
  • Start date Start date
B

brendon

Does anybody know how i can count the number of unique
records in a list.

thanks in advance.
 
First, highlight all the names and select Insert | Name | Define from the
menu to give the range a name. I called it Names. Now enter this formula:
=SUM(1/COUNTIF(Names,Names)). Now this is very important: Press
Ctrl-Shift-Enter rather than only Enter; this will tell Excel to make it an
array formula.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Hi
use the following formula
=SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&""))
if A1:A1000 is your range with data
 
Back
Top