I used the code re previous thread http://www.excelforum.com/excel-gene...ce-number.html on another group of headings, spread sheet attached. However this one is on therapies given to a patient in a month, so one patient might have had several different treatments, but only one is showing.

How can I get

Month of treatment against each reference number
what treatment/s a patient (reference number) has had and in what month and total number of treatments over the year
total number of treatments given per month ie counselling, aromatherapy etc

Thanks in advance.

(therapies.xlsb

Raised as a new thread as I couldn't upload new spreadsheet in previous thread)