This is part of a set of billing calculations.
The breakdown is as follows:
I have clients who are part of a Case Number. There are a minimum of 3 clients associated with each Case Number. Each client has a designator assigned to them: i.e. mother, Jane Doe, would be "M"; child1, Mary Doe, would be CH1; Child2, Jack Doe, would be CH2; man1, John Doe, would be TM1; man2, Joe Doe, would be TM2; and so on. If there are more than 3 clients then the Case Number is broken down into sub Case Numbers. The clients have a certain billing fee which needs to be billed only once. My problem is limiting that charge to 1 time no matter how many times the client appears in the groupings.
Examples (see attached .txt file)
Once I know how to limit each client to be charged only once I think I can work out the rest of the Billing calculations.