Question

[aroraaj]

I have a excel sheet and one of the column has list of suppliers. For example:

NBT
NBPC
NBT
ESO
ECO

I need a formula that will count how many suppliers are there and I don't want it to double count the ones that are already listed. For example there are two ESO and two NBT I only want that to count once. Is there a way to do that?

 

[Jonmo1]

Try this

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

Note, the ranges cannot be entire column refs like A:A, must use row #s like A1:A1000
Unless in xl2007

Hope that helps..

 

[Jon von der Heyden]

Edit: Deleted - Jonmo got there first.

 

[aroraaj]

That works. Thanks for the help!