Count Most Consecutive Months a name appears

[audiofreak]

Hi,

I have about two years worth of data pertaining to sales on a worksheet called "SHEET1". For this purpose, the data I am interested in is: Column C which is the Date, Column E which is the Seller Name. It is organized by date in ascending order. (There is other data in more columns as well not needed for this)

I want to keep track of the most consecutive months each person's name appears on this sheet and report that number in a cell on a second worksheet "SHEET2". SHEET 2 has every seller's name (once) in column A.

I've attached dummy sheets in a much smaller version to give you an idea of what they look like.Example Sheet1.xlsx

I appreciate any help you can offer!

Thank you so much!

[:) Sixthsense :)]

Everything is clear except the expected output, it will be very much helpful if you show the expected output too....

[MarvinP]

OK audiofreek,

Find the answer that was a little harder than normal. I needed to sort your data first by date and then by name. Then I put in two helper columns. First to extract the month and second to see if it was "consecutive". Then on sheet 2 comes an Array Formula that must be entered with a Ctrl+Shift+Enter keystroke combination. Find the attached with the answer.

[audiofreak]

Thank you so much! I'm checking it out now, and so far it looks good! I had a feeling it might need extra work parts and I appreciate your help!