I would like to perform a count of data, based on the number of times an item is referenced. On one sheet I have the items I wish to count, the data on a second, and the references in a third.
My data returns a number for the column i would like to count, but this needs to be 'interpreted' into a category. Any help would be appreciated
Data:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Reference:
<colgroup><col><col></colgroup><tbody>
</tbody>
Analysis: (where I want it to say how many times each item has occurred in the data)
<colgroup><col></colgroup><tbody>
</tbody>
T.I.A.
My data returns a number for the column i would like to count, but this needs to be 'interpreted' into a category. Any help would be appreciated
Data:
Time of Incident | Type of Incident | Mechanism of Accident: | Treatment of Injury |
10:50am | Accident | 5 | First aid only |
11:10am | Accident | 5 | First aid only |
12:00am | Discomfort | 3 | None |
9:00am | Accident | 5 | First aid only |
3:00pm | Discomfort | 8 | None |
10:00am | Discomfort | 3 | None |
6:15am | Discomfort | 6 | Hospitalisation |
3:10pm | Discomfort | 3 | None |
3:30pm | Near Miss | 9 | None |
3:46am | Accident | 5 | First aid only |
2:30am | Discomfort | 3 | None |
1:00am | Accident | 5 | None |
7:00am | Near Miss | 9 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Reference:
Mechanism of Accident | |
1 | Fall, trip or slip |
2 | Sound or pressure |
3 | Body stressing |
4 | Mental stress |
5 | Hitting objects with part of the body |
6 | Biological factors |
7 | Heat, radiation or energy |
8 | Chemical or other substances |
9 | Being hit by moving objects |
<colgroup><col><col></colgroup><tbody>
</tbody>
Analysis: (where I want it to say how many times each item has occurred in the data)
Mechanism of accident |
Fall, trip or slip |
Sound or pressure |
Body stressing |
Mental stress |
Hitting objects with part of the body |
Biological factors |
Heat, radiation or energy |
Chemical or other substances |
Being hit by moving objects |
<colgroup><col></colgroup><tbody>
</tbody>
T.I.A.