Hi All,

I have several rows of data which I need to compile into a summary type
format.

Source data

Index Unit Patch Folder No.
1 D0X D2X 1
2 D0X D2X 1
3 D0X D2X 1
4 D0X D2X 1
5 D0X D2X 1
6 D0X D2X 1
7 D0X D2X 1
8 D0X D2X 1
9 D0X D3X 1
10 D0X D3X 1
11 D0X D3X 1
12 D0X D5X 1
13 D0X D5X 1
14 D0X D6X 1
15 D0X D6X 1
16 D0X D6X 1
17 D0X D8X 1
18 D0X D8X 1
19 D0X D8X 1
20 D0X D8X 1
21 D0X D8X 1
22 D0X D8X 1
23 D0X D8X 1
24 D0X D8X 1
25 D0X D8X 1
26 D0X D8X 1
27 D0X D9X 1
28 D0X D9X 1
29 D0X D9X 1
30 D0X D9X 1
31 D0X D9X 2
32 D0X D9X 2
33 D0X D9X 2
34 D0X D9X 2
35 D0X D9X 2


What I need to do is match the Unit to the folder Number and return the min
and max index numbers, all the patches contained within that range and the
folder number with the Max folder number after that (eg. 1 of 6)

Output

Index Start Index End Unit Patch Folder No.
1 30 D0X D2X, D3X, D5X, D6X, D8X, D9X 1 OF 6
31 45 D0X D9X, DAX 2 OF 6
46 49 D0X DAX 3 OF 6
50 79 D0X DDX, DEX, DFX 4 OF 6
80 92 D0X DFX, DGX 5 OF 6
93 107 D0X DGX, DHX, DJX, DKX 6 OF 6


When the code has completed the output needs to be as shown above

I think that I need to use an array to do this but I have no idea where to
start. Can anyone help me please.

Any and all help would be greatly appreciated.

Regards

Mick