Ron,

I shouldn't have to be dealing with Circular References. I don't know how to solve them, especially at this point. Maybe its not that hard but it feels that way.

No, your solution didn't work. The text string should be based on the K and I values; I shouldn't have to add in another column to get to what I need. They are coded as General. They are also the pre-existing values that the Unique label should be based on.

Maybe the best way to describe my situation is this.

Start with the sets of duplicate ACCIDENT NUM. Take the Pattern of values in the K and I fields for each set of Duplicates, and Group them.
Label the Group.
If the next set of Duplicate Ids has a different Pattern of values in the K and I fields, Group them and label them as well.
For the next instance of a Previous Pattern of values, use the same label as the one you had created before.
Create a Count field for the Groups of Data and count the number of instances of each Group.

If there is a simpler way to do what I have just described than even the formulas I have had to deal with, then I am all ears. I would like to think that this could be done in two fields and not 4-5 like what I am dealing with but this is as close as I have gotten.

Use SHEET 8 and the values in ACCIDENT NUM, KILLED, and INJURED to do this. I would like to think it should be as simple as:

K I PATTERN LABEL COUNT
0 0
0 0
0 0 000000 a 2

1 1
1 1 1111 b 1

0 0
0 0
0 0 000000 a

1 0
1 0 1010 c 1



Dan