count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=COUNTIF(A:A,"00020084")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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
 
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)
 
Hi Bob - perfect - thanks heaps for your help !

Bob Phillips said:
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)
Click to expand...
 
Back
Top