| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
count
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count
=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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count
Hi Bob - perfect - thanks heaps for your help !
"Bob Phillips" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals by count | Excel Discussion (Misc queries) | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Linear Mode
