Tony and Glenn:

Maybe this will work:

How would I:

1) GROUP sets of values together,

2) Create a "Pattern" number (label?) based on the Pattern

3) Do a Count of the Pattern Types in the whole spreadsheet/database?


ACCIDENT NUM KILLED INJURED PATTERN COUNT

12345 0 0
12345 0 0
12345 0 0 1 1

123456 0 0
123456 0 0 2 1

123345 0 0
123345 0 0 2 2

1235456 0 0
1235456 0 0
123456 0 0 1 2

123444 1 1
123444 1 1 3 1

1234445 0 0
1234445 0 0 2 3


How would I create a Pattern Number (PATTERN FIELD)?

In other words, Pattern 1 = 0,0 (3x), Pattern 2 = 0,0 (2x), Pattern 3 = 1,1 (2x), and so on...and Count = SUM of Number of times for Pattern 1, Pattern 2, Pattern 3....

How could I use GROUP to Group the values in KILLED and INJURED and have it equal Pattern 1, Pattern 2, etc...?

(Count is something I'll need but its probably simple enough, I would think, Yes? TOTAL of Patterns in Pattern Field, like =SUM("1",B2:B5, SUM("2",B2:B5), etc.

I could send a database if needbe but the main thing is what is the procedure involved---functions et al.

Dan B