serial number decode

[Guest]

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?

 

[Guest]

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.

 

[Guest]

But my data is in alphabet

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.

 

[Guest]

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:

 

[Guest]

i just did that. i thought there was an easier method.

 

[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

 

[Pete_UK]

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

Pete