J
Jim
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
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