serial number decode
 

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?

serial number decode
 

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.


--
Allllen


"chiuinggum" wrote:

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?

serial number decode
 

But my data is in alphabet

"Allllen" wrote:

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.


--
Allllen


"chiuinggum" wrote:

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?

serial number decode
 

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:

But my data is in alphabet

"Allllen" wrote:

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.


--
Allllen


"chiuinggum" wrote:

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?

serial number decode
 

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

"Marcelo" wrote:

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:

But my data is in alphabet

"Allllen" wrote:

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.


--
Allllen


"chiuinggum" wrote:

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?

serial number decode
 

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

chiuinggum wrote:
i just did that. i thought there was an easier method.

"Marcelo" wrote:

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:

But my data is in alphabet

"Allllen" wrote:

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.


--
Allllen


"chiuinggum" wrote:

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?

serial number decode
 

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

Pete

Pete_UK wrote:
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

chiuinggum wrote:
i just did that. i thought there was an easier method.

"Marcelo" wrote:

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:

But my data is in alphabet

"Allllen" wrote:

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.


--
Allllen


"chiuinggum" wrote:

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?