Product Report Showing Ranges and Missing Values

Hi guys, I got an issue where if someone can help me create a report it will save a whole lot of manual work.

I have a file with four columns.

1 is the SKU (product ID) 2 is Size 3 is Colour and 4 is Length

I need a formula that will group the sku's together , and secondarily the colours, and print me the first and last size listed for that sku, for each colour, with any missing sizes inbetween listed as 'missing'

The list of sizes and their order is on a second worksheet.

In the end, a list like:

A1094 *** SIZES = 32AAA - 48FF *** COLOURS = RED, BLUE & WHITE *** MISSING SIZES/COLOURS = 34D WHITE, 36F BLUE

T104 *** SIZES = XSMALL - 3XL *** COLOURS = GREEN, BLACK, BROWN *** MISSING SIZES/COLOURS = XSMALL GREEN, 2XL BLACK

for each product would be awesome.

I can offer a free pair of underpants to the successful superhero - we sell them as a company - nothing untoward :-)

Thanks in advance

Steve @ Woods of Morecambe