You could refer to the cell

COUNTIF(A:A,A1)

but many numbers will repeat.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Lacey" wrote in message
...
Hi Bob - thanks - this worked for the one row and idenifying the one
person
- but I need to drag this formulae down looking at over 100 cells - any
ideas?
thanks

"Bob Phillips" wrote:

=COUNTIF(A:A,"00020084")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Lacey" wrote in message
...
Hi - I'm hoping someone can help me - i have a list of employees (col
A)
who
have been awarded $ amounts (col B). I need to count the number of
times
they have received an award... really would appreciate any help...
thanks

00020084 1,500.00
00020084 1,000.00
00020084 500
00018539 1,000.00
00018539 1,500.00
00028267 1,000.00