Hiya,
I have a spreadsheet of member details; names, contact details, date of birth.
The sheet will have multiple entries for the same person; and obviously, some dates of birth with will multiples.
I want to be able to count the of dates of birth for unique names. Example shows the count i would be expecting in column D.
| A | B | C | D |
| David | Jones | 22011986 | 01 |
| David | Jones | 22011986 | 01 |
| Paul | Harrison | 08091979 | 01 |
| Simon | Edgar | 10071980| 01 |
| Sam | Smith | 08091979 | 02 |
| Anthony | Jeffs | 22011986 | 02 |
I've racked by brains on an answer!
Any help??!