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?

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?

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?

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?

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?

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?