count unique

[brendon]

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

thanks in advance.

 

[Anne Troy]

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

 

[Frank Kabel]

Hi
use the following formula
=SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&""))
if A1:A1000 is your range with data