+ Reply to Thread
Results 1 to 4 of 4

Count Most Consecutive Months a name appears

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    United States
    MS-Off Ver
    Excel 2008 Mac
    Posts
    16

    Count Most Consecutive Months a name appears

    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!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Count Most Consecutive Months a name appears

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


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,991

    Re: Count Most Consecutive Months a name appears

    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.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    08-17-2012
    Location
    United States
    MS-Off Ver
    Excel 2008 Mac
    Posts
    16

    Re: Count Most Consecutive Months a name appears

    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1