Are you guys.....

Ok. I at least made some progress today--the person who helped me out on this earlier created some formulas that are bloody simple, but the only problem is that they are not entirely dynamic enough for a Several Thousand record database with the bulk of the data sets being in 2 record format ("0000").

See the attached spreadsheet and look at the formulas involved.

I will explain more if needbe but the answer as to how to make the text string more flexible in the Unique Field and how to get the Patterns2 values to be more flexible as well can't be that hard.

If I can get formulas this simple this close to working I have a feeling I can see the goal line...

Dan