Hi there, I have a large column of postcodes listed and I am trying to group these into 6 Territories (T1 - T6 in another column). Is it possible to do this and for excel to remember these groups if the same postcodes come in the next month?

So to sum up the postcodes refer to a quantity despatched to that postcode and the postcodes go into 1 of 6 territories. I am trying to group the quantity sold in each territory.

Is this possible. I feel like I should know how to do this but it's just not working!