| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Data Within Range
Dear All,
I have a spreadsheet with aroung 12, 500 lines. The sheet contains info about trainees and values recieved for training. I wanted to count the number of times a specific word, located in column J appeared against each trainee. Trainees are identified by a unique code in column B. Any help would be greatly appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Data Within Range
Where are you searching for the specific word? Assuming you are searching in
Col C thru I, put in Column K the foillowing: =COUNTIF(C1:I1,J1) and propagate to all cells in Column K. Regards, Antonio Elinon "Sukh" wrote: Dear All, I have a spreadsheet with aroung 12, 500 lines. The sheet contains info about trainees and values recieved for training. I wanted to count the number of times a specific word, located in column J appeared against each trainee. Trainees are identified by a unique code in column B. Any help would be greatly appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Data Within Range
=SUMPRODUCT(--(B1:B100="trainee_name"),--(J1:J100="word"))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Sukh" wrote in message ... Dear All, I have a spreadsheet with aroung 12, 500 lines. The sheet contains info about trainees and values recieved for training. I wanted to count the number of times a specific word, located in column J appeared against each trainee. Trainees are identified by a unique code in column B. Any help would be greatly appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Data Within Range
This will count the number of times ABC appears against code of 123.
HTH =SUMPRODUCT(--(B2:B12500=123),--(J2:J12500="ABC")) "Antonio Elinon" wrote: Where are you searching for the specific word? Assuming you are searching in Col C thru I, put in Column K the foillowing: =COUNTIF(C1:I1,J1) and propagate to all cells in Column K. Regards, Antonio Elinon "Sukh" wrote: Dear All, I have a spreadsheet with aroung 12, 500 lines. The sheet contains info about trainees and values recieved for training. I wanted to count the number of times a specific word, located in column J appeared against each trainee. Trainees are identified by a unique code in column B. Any help would be greatly appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count time formatted data within range | Excel Worksheet Functions | |||
| how to select and count from a range of data | Excel Discussion (Misc queries) | |||
| Count range of data | Excel Worksheet Functions | |||
| Countif count items not in data range | Excel Discussion (Misc queries) | |||
| How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
Linear Mode
