Hi all,

I've searched long and hard for the solution to this one.

I have a spreadsheet where I input what volunteers attend each session.

So the cell that contains volunteers looks like this: Ra Ry Ch

I'm looking to be able to count up the number of unique volunteers attended sessions of a period of time.

I've tried a formula like: =SUMPRODUCT((D4:D41<>"")/COUNTIF(D4:D41,D4:D41&"")) However this only counts the number of unique entries for cells as a whole, not the individual initials within the cells.

For example if the cells look like this:

RE TY FT
TY RE BE IL
RE TY FT
IL TY
IL TY

The above formula will return 3, however I would like it to return 5 as this is the number of unique volunteers to have attended sessions for this time period. Hopefully this makes sense, I've attached an example workbook.Example.xlsx

I understand that there may not be a solution to the way I've set up the data, so if there is another way to count volunteers let me know.

Thanks for your time