serial number decode

C

chiuinggum

i have a month code table.

A or B denote January
C or D denote Febuary and so on until Dec.

How can I decode a list?
 
A

Allllen

In the same way as you coded it: with a reverse table

So for table
A or B Jan
B or C Feb
D or E Mar

Just make another that says
Jan A or B
Feb C or D
Mar E or F

If you want it to say which between A and B, you will have to tell us and
Excel what the difference between A and B is.
 
C

chiuinggum

But my data is in alphabet

Allllen said:
In the same way as you coded it: with a reverse table

So for table
A or B Jan
B or C Feb
D or E Mar

Just make another that says
Jan A or B
Feb C or D
Mar E or F

If you want it to say which between A and B, you will have to tell us and
Excel what the difference between A and B is.
Click to expand...
 
M

Marcelo

Hi, do you have a single column with the codes? and you would like to have in
another column the corresponding month?

eg:
A Jan
B Jan
D Feb
E Mar
F Mar
C Feb

If you, so create a table like

Col A Col B
A Jan
B Jan
C Feb
D Mar
E Mar
F Apr
G Apr
H May
etc

and use a Vlookup to find the corresp month for each code.

hope this helps
regards from Brazil
Marcelo

"chiuinggum" escreveu:
 
P

Pete_UK

If you have a letter in cell A1, this formula will show the month by
calculation (i.e. no need for a separate table):

=IF(A1="","",VALUE("1/"&INT((CODE(UPPER(A1))-65)/2)+1&"/2006"))

You can copy the formula down. It will recognise "A" and "a" through to
X. If the cell in column A is blank it will show a blank. If column A
has Y or Z or a number, then you will get #VALUE.

Hope this helps.

Pete
 
P

Pete_UK

Sorry, forgot to say - format the cell containing the formula using
Custom and set to MMM.

Pete
 
Top