+ Reply to Thread
Results 1 to 3 of 3

Retun Nth Non-Blank Occurrence of Condition

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Retun Nth Non-Blank Occurrence of Condition

    I'm using Excel 2007. On the attached spreadsheet, I'm really only concerned with the formulas that I have in the grey shaded area.

    The formula is correctly displaying the 1st, 2nd, 3rd & 4th helper (person) for each PO# (Job) listed vertically in the columns to the left. I need the helpers for each PO# repeated for each occurrence (day) of that same PO# so that I can properly summarize this data in the pivot table I've included on the attached example.

    As you can see, since not each occurrence of the same PO# has a helper, the the formula is displaying a zero in the grey shaded area for that blank cell. I wish for the formula to ignore the blank helper cell instead of counting that as the Nth occurrence. In the attached example, I want helper John Doe (cell H2) and helper Mary Jane (cell I2) to be shifted to the left under the Helper 1 and Helper 2 columns since the are really the 1st and 2nd occurrence of a helper for PO# H00843 (there was no helper on the first day of the job). This is a little hard to explain in words but I think the attached spreadsheet will make it much clearer.

    I appreciate any help that you can provide.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: Retun Nth Non-Blank Occurrence of Condition

    Like this then?
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    05-15-2013
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Retun Nth Non-Blank Occurrence of Condition

    It looks like that did it. Excellent! Many thanks.

+ 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