Hello fellow spreaders of sheets (oo er), I'm new here. I'm looking for help with reporting on a spreadsheet (around 5,000 rows) of data mainly consisting of postcodes that I get each week. The data i get should have a postcode in the usual UK format of AB12 3CD, multiple postcodes seperated by a comma, or a "0". Now the box that people type this data into is a free text box, so there is no validation applied to it before i get this data. Alongside each postcode is a reason for the postcode being entered, this is chosen by the clicks a person makes before typing postcodes. We use this data to determine trends, so always need the postcode and reason to stay together.

My data originally looks like this:

Postcodes before.PNG

I seem to have gotten the validation of wether the text contains a postcode by using this UDF: http://jtsbraindump.blogspot.co.uk/2...-in-excel.html .

I have then extracted these postcodes using this: http://www.ozgrid.com/forum/showthre...155183&page=2& .

I'm also transposing any multiline cells like this: http://www.mrexcel.com/forum/excel-q...osed-rows.html .

So, my data now looks (mostly) like this:

Postcodes after.PNG

I do however have some concerns i need help with:

1, I don't think i'm grabbing the multiple postcodes, there are no extra rows created and i would also need the reason to copy over too.

2, I've done some simple COUNTIF's on how many times a postcode appears, but again i need it to be in the context of it's reason. So it may appear 5 times in the whole sheet but i need to know if that's twice for reason 1 and 3 times for reason 2 not just all together.

3, I need to start producing reports to these levels on a postcode like this AB12 3CD:
AB
AB1
AB12 3
AB12 3CD

Any thoughts?

Cheers in advance

Rye