Counting Mutiple Numbers in Single Colum

[keepitfrozen]

I have a list of Work Order Numbers in a list and each work order number shows up numerous times in the list but I want to know how many Work Orders i have in the list but do not want to count the duplicates. I sure could use some help with this.

Thanks,

KIF

[richardreye]

try this

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))

Of course, adjust the range to suit your data.

Follow this link to get an explanation on this if you would like

http://www.mrexcel.com/board2/viewtopic.php?t=73502

Cheers!

[keepitfrozen]

I think that is going to work perfect while I'm not totally clear on how it works I'm going to read that thread you suggested a few times and see if i can get it. thanks so much, now i can get that report out before tommorow morning.

thanks again,

KIF