+ Reply to Thread
Results 1 to 4 of 4

Prioritization countif function

  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    20

    Prioritization countif function

    Hello,

    I have received help with this file which has been instrumental. If you look at Sheet 1 I have an area where items are listed if they are before the current date, meaning they are late. Here is my question. In the data sheet I would like all the late items to populate in rows 6-37 before the regual data for that date. In other words it is making late items the first scheduled priority for that day and then regularly schedule items would fill the remaining capacity. I have tried to make variations of the current formula but cannot figure out how to make the items before current date populate first. Any ideas?
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Prioritization countif function

    So are you saying the top table is correct and you don't want the bottom to show duplicates of the top table, or vice versa? Or is it something else?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    09-13-2011
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Prioritization countif function

    I would like the top data to incorporate the data from the bottom area, rows 53-86 if there are late items. The ultimate goal is for the sheet to automatically insert late items on the now date so that these are automatically scheduled. Then once the late items were input any other item with the correct date would be filled in. Sorry if my last was not clear.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Prioritization countif function

    Not sure if I understood, but perhaps you can use the method you are currently using in those tables, but look at bottom section instead of Data sheet.

    So you would add a helper to bottom section, in K53:

    =IF(F53="","",F53&"_"&COUNTIF(F$53:F53,F53))

    copied down

    In E3,

    =COUNTIF($K$53:$K$86,Sheet1!A$4&"*")

    in A6:

    =IF(ROWS($A$2:$A2)>$E$3,"",INDEX(A$53:A$86,MATCH($A$4&"_"&ROWS($A$2:$A2),$K$53:$K$86,0)))

    copied down and across the columns.

    Repeat with adjustments for the other upper tables.

    is that what you were looking for?

+ 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