[RESOLVED] Reading a column of data and summarising the data based on codes

[scoobster247]

Hi Forum

Please see the data example below. This is a small block of data for 2 countries (Belgium and Austria). Within these these are zip codes and zip groups (the first 2 characters of the zip code), and the name of the team working within the zip. There can be one or more teams working within a zip group.

What I need is to summarize the data so that I get the lowest and highest zip group for a team within a country. If there is more than one team working within a zip group then I need the lowest and highest zips. If these is only one team working in a country then I just need the lowest and highest but also a comment to say only one team for that country.

The lowest and highest values I need are from reading the file from start to finish. By that I mean I don't need the highest value for that team within the entire block of data.0

If there is only one 'team' for a zip group then I want to output the lowest and highest consecutive zip group for that team.
If there are more than one 'team' for a zip group then I want to output the lowest and highest consecutive zip for that team.
If within a country there is only one 'team' then I want to output the lowest and highest consecutive zip group for that team and add a comment of 'complete "country"'

The expected output based on the source data is shown at the bottom of the image.

Is it possible?

Many thanks for your help.