Counting distinct

[Rita Palazzi]

Windows XP Professional
Office 2000

I have long list of airway bill numbers. Some of them are repeated
within the same column. How do I count the distinct number of awb's in
the column? I've probably asked this before, but am having a "blonde
moment". (smile)


Thanks for any help!
Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express

 

[Ron de Bruin]

Try this array formula

Read this first
http://www.cpearson.com/excel/array.htm

=SUM(IF(LEN(A1:A10),1/COUNTIF(A1:A10,A1:A10)))

More info on this page
http://www.cpearson.com/excel/duplicat.htm#CountingUnique

 

[Rita Palazzi]

I don't understand how or why, but it did work.
Thanks!
Rita