grouping similar data

[smuthcrmnl777]

I have a grouping of samples that are collected either at the same time or at different times of the day. They are date stamped and time stamped. The samples have a name that the are similar. Each sample group will have either an F, -F or /F at the end of the sample name.

I need to place a numeric value next to each group of 2. This way I can group them as a separate task instead of taking all 4 samples and grouping them as 1.

2/7/2006	9:35:26	40-69-REJ	[COLOR=red]1[/color]
2/7/2006	9:36:52	40-69-REJ-F  [COLOR=red]1[/color]
2/7/2006	9:37:56	40-69-REJ	[COLOR=red]2[/color]
2/7/2006	9:48:52	40-69-REJ-F  [COLOR=red]2[/color]

 

[lynchg]

What is the basis in your example for these groupings? I don't see it in the data displayed.

There needs to be a clear distinction between the groupings in order to get started.

 

[smuthcrmnl777]

There is an element that is tested for each sample. The top row means they checked an element once and then the 2nd sample means they Flipped (-F) the sample over and checked it again.

Then they will repeat the test as many times naming it the same thing. They have to check it many times until the element is in spec.

The only basis I see is Time. A flipped item will always occur after the original has been tested. That is why the first two lines correcpond and the last two correspond together.