View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default What is the average month

There may be a better way, but this works.

Ctrl/Shift/Enter this in a cell in column A and it will return the month
which appears the most frequently in column B -- it assumes the months are
entered as text: "Apr" or "Sep" instead of 4/1/2009 or 9/14/2009, etc.
=TEXT(MATCH(MAX(COUNTIF(B1:B63,TEXT(ROW(1:12)&"/2000","mmm"))),COUNTIF(B1:B63,TEXT(ROW(1:12)&"/2000","mmm")),0)&"/2000","mmm")


"Jim" wrote in message
...
Hello,

This is a great forum and I appreciate all the help.

In a worksheet I have a ton of data. However in Column B I have the
transaction month of purchases. For most rows the month is the same but
there are times where it reflects the month prior.

In column A I would like to show the billing month for the line. The
question is how do I write a formula to look at the entire column and show
the month that appears most in column B and return this month to column A.

Thanks
Jim