Hi
I need a simple formula that creats an id code for each 2-digit country code. I have filled out an example on the attachment.
For example the next cell to fill in would be B23, B24 and B25 all would get an id number 7.
Is there a formula for this. In reality I have loads of 2 digit country codes.
Many thanks.
Chris
Bookmarks