It depends.

If you need a formula, then you have to write a macro, as far as I know.

If you want a one time count, then create a pivot table with just this column,
then count the number of items. If you can sort the list, in a new column use
a formula like IF(A2=A1,0,1), then make the sum of this column.


Sena wrote:
I have a list of codes in a column, each code will be appearing many times. I
need to count the number of codes - how do I do it.

eg:
A100
B100
A100
A100
B100

Number of codes in the above list are 2.

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1