Using an equation to count non-duplicated items in column

[carla]

I have a list of trailers in a sheet that are designated as T-####. Is
there a way to count the number of non-duplicated entries in this
column by using a formula?

Thanks for any assistance,
Please respond to hers2keep @ yahoo . com.

Thanks,
carla

 

[Gord Dibben]

carla

Try Chip Pearson's site........

http://www.cpearson.com/excel/duplicat.htm#CountingUnique

BTW. The customary response is to the News Group, not email.

That way we all learn.

Gord Dibben Excel MVP XL2002