Hi, I have a spreadsheets that contains a list of incidents by date. The date therefore appears numerous times (column A) and various codes appear in the 2nd column (column B). How do I count the number of times the code in column B appears by date (column a)? Sounds simple but I have a brain fog at the moment! thanks.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Date | Incident | ||
23/01/2019 | BA | ||
23/01/2019 | CD | ||
23/01/2019 | CA | ||
23/01/2019 | BA | ||
23/01/2019 | DA | ||
24/01/2019 | CD | ||
24/01/2019 | BA | ||
24/01/2019 | BA | ||
24/01/2019 | AD | ||
24/01/2019 | CD | ||
24/01/2019 | BA | ||
24/01/2019 | AB | ||
24/01/2019 | CB |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>