Summation based on alpha season code

**MATTOON250** · 07-07-2009, 01:22 PM

I am working on an inventory report that the owner would like broken out between in-season items and out of season items. Items with no season code are always in season. Items that have seasonality have a 2 digit season code. A as if Jan, B is Feb, etc. A season code might be CE or KB. CE would be in season from March until May. KB is in season from Nov through Feb and out of season the rest of the year.

We are currently in month G. Is there an easy way to use the two digit season code and determine if G falls in between those two months.

Thanks in advance,

**DonkeyOte** · 07-07-2009, 01:30 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

In short yes I'm sure you can do what you want but it would be helpful to be able to visualise your layout and understand what you're trying to output etc...

**Bob Phillips** · 07-07-2009, 01:42 PM

Try this

=IF(CODE(LEFT(UPPER(N1),1))>CODE(RIGHT(UPPER(N1),1)),
OR(CODE(UPPER(N2))>=CODE(LEFT(UPPER(N1),1)),CODE(UPPER(N2))<=CODE(RIGHT(UPPER(N1),1))),
AND(CODE(UPPER(N2))>=CODE(LEFT(UPPER(N1),1)),CODE(UPPER(N2))<=CODE(RIGHT(UPPER(N1),1))))

**MATTOON250** · 07-07-2009, 01:45 PM

Attached is a small portion of the information I am working with. I have the 2 digit season code and I know the current month is G. I am looking to populate the "In Season ?" column with a true or a false. If G falls between the two season letters, that cell would be true; else it would be false.

Thanks,

**Bob Phillips** · 07-07-2009, 02:02 PM

Just adapt my formula

=IF(CODE(LEFT(UPPER(C2),1))>CODE(RIGHT(UPPER(C2),1)),
OR(CODE(UPPER(A2))>=CODE(LEFT(UPPER(C2),1)),CODE(UPPER(A2))<=CODE(RIGHT(UPPER(C2),1))),
AND(CODE(UPPER(A2))>=CODE(LEFT(UPPER(C2),1)),CODE(UPPER(A2))<=CODE(RIGHT(UPPER(C2),1))))

**MATTOON250** · 07-07-2009, 02:15 PM

Originally Posted by Bob Phillips

Just adapt my formula

=IF(CODE(LEFT(UPPER(C2),1))>CODE(RIGHT(UPPER(C2),1)),
OR(CODE(UPPER(A2))>=CODE(LEFT(UPPER(C2),1)),CODE(UPPER(A2))<=CODE(RIGHT(UPPER(C2),1))),
AND(CODE(UPPER(A2))>=CODE(LEFT(UPPER(C2),1)),CODE(UPPER(A2))<=CODE(RIGHT(UPPER(C2),1))))

Bob,

A2 in the spreadsheet was the letter of the store I was dealing with. I just substituted the month Letter in for A2 and it worked like a charm.

Thank you very much!!!

**Bob Phillips** · 07-07-2009, 02:30 PM

Originally Posted by MATTOON250

Bob,

A2 in the spreadsheet was the letter of the store I was dealing with. I just substituted the month Letter in for A2 and it worked like a charm.

Thank you very much!!!

I don't know what went wrong there. I moved the values to avoid mis-typing - so much for that.