Results 1 to 1 of 1

Generate list of names based on multiple criteria

Threaded View

mattadler22 Generate list of names based... 05-03-2013, 06:02 PM
  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    15

    Generate list of names based on multiple criteria

    Please see the attached spreadsheet. Table 1 is Fill, Table 2 is Vol, and Table 3 at the bottom is simply a sumif based on values in table 1 and 2. My end goal is hard to explain, so I'll give an example.

    I want the output to be something like this:

    Group 1:
    A, D, F
    1, 10, 15, 20, 25

    Condition for group 1 is that Total Vol for A, D, F is at least 70% of original if still faced 1-30

    So what I'm trying to do is identify values in 1-30 that A-I have in common, and by grouping them together the average Fill would increase without decreasing the total Vol amount too much.

    I understand this may be confusing, so please let me know if this isn't clear. Thank you so much!
    Attached Files Attached Files

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