raphaello
col B = entrant number (as per your screen shot)
col C = age group . to be selected from drop-down your screen shot shows ths drop down list in c23-27 . you have overlapping options (16-17, 17-30 then you have 18-18, 17-31 , finally 26-30)
I moved the "drop down selection " to column E and tidied it up a bit to remove overlaps. You can re-jig the age groups to suit youself. and the formula below will still work provided you keep to 4 age groups . If you want more or less age groups you will need to modify the formula
formula in F1 =CONCATENATE(E1," ",COUNTIF(C2:C20,E1)," times, ",E2," ",COUNTIF(C2:C20,E2)," times, ",E3," ",COUNTIF(C2:C20,E3)," times, ",E4," ",COUNTIF(C2:C20,E4))
I wanted to be in new lines for each age group but cant get that bit to work
| number | agroup | | 16-18 | | 16-18 3 times, 19-25 3 times, 26-30 5 times, 30-99 1 |
| 1 | 16-18 | | 19-25 | | |
| 2 | 26-30 | | 26-30 | | |
| 3 | 26-30 | | 30-99 | | |
| 4 | 19-25 | | | | |
| 5 | 26-30 | | | | |
| 6 | 19-25 | | | | |
| 7 | 16-18 | | | | |
| 8 | 16-18 | | | | |
| 9 | 26-30 | | | | |
| 10 | 19-25 | | | | |
| 11 | 26-30 | | | | |
| 12 | 30-99 | | | | |
<COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 454pt; mso-width-source: userset; mso-width-alt: 22125" width=605><TBODY>
</TBODY>