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:
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 |