=COUNTIF($A:$A,A1)
HTH Otto

"AAA1986" wrote in message
...
Each entry in my database has a category listed in column A. I would like
to
create a column that produces the n for each entry's category.

For example, if column A reads:
blue
red
red
green
green
green

Then column B should read:
1
2
2
3
3
3

Anyone know what formula I can use for this column B?

Thanks in advance.