View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen
 
Posts: n/a
Default 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?