Grouping one column into categories

Hi,

Do you have a definitive list of which postcodes go in which Territory?

Regards

No, but what I mean is: are these Territories already defined?

So that what you want to do is, given a particular postcode, say, to be able to have Excel automatically tell you which Territory that postcode belongs to?

This is perfectly possible, but it requires you to have that definitive list of Post Codes/Territories in the first place.

Regards

Then one possible solution would be to use a VLOOKUP.

For example, supposing you had a postcode in Sheet1 cell A1 for which you wished to know the Territory. Suppose also that your list of postcodes and Territories is in Sheet2, beginning in row 2 and ending in row 7000 with, as you said, postcodes in column C and Territories in column G. Then you would enter this formula (in e.g. Sheet1 B1):

=VLOOKUP(A1,Sheet2!$C$2:$G$7000,5,0)

You could make this end range reference (7000) arbitrarily larger so that, if and when you add further records, they will be included in the search, without any negative effects.

Regards

But that's exactly what you'd do with that formula I posted.

Once you have one formula (in e.g. cell B1) which refers to e.g. the postcode in cell A1, and tells you what territory it is (by searching in the table you've created), all you then do is copy/drag that formula down (to cell B2, B3, etc.) so that it will automatically give you the territories for the postcodes in cells A2, A3, etc.

If you're still not clear, all I can suggest is that you post a couple of sample workbooks: one being the table you're creating which lists all the territories and their respective postcodes (remove or 'dummy' any sensitive/confidential information in there if you need to), the other an example of the 'results' sheet you'd like to have where, for example, you type in a postcode and it tells you automatically to which territory it belongs.

Regards