Finding Mismatched Months

Hello, I need some help please. In the attached file I am trying to find any mismatches between the month in column A and the month number in column B. Is there a formula or macro that will give me, in column C perhaps, a TRUE if the months match and a FALSE if the months do not match?

Thank you in advance.

Mismatched Months.xls

You can probably do a TextToColumns on Column A then use formula to compare the month between the two columns.

Try this:

Please Login or Register  to view this content.

If you want just the month (as you said), ConneXionLost's formula will give you what you need. If you want to include the year as well, try this...

=TEXT(MONTH(B1),"mmm")&" "&RIGHT(YEAR(B1),2)=MID(A1,LEN(A1)-5,99)

I noticed that in both cases, it becomes a little hard to see the TRUE's from the FALSE"s, have you considered using conditional formatting to change the color of the cells that match?

1. highlight the range you want to apply the conditional formatting to (say, C1:C1000)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =MID(A1,LEN(A1)-5,3)=UPPER(TEXT(B1,"mmm"))

or if you want to include the year as well...

4. enter =TEXT(MONTH(B1),"mmm")&" "&RIGHT(YEAR(B1),2)=MID(A1,LEN(A1)-5,99)