Results 1 to 9 of 9

listing array values in a dynamic list based on 2 criteria from ranges

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2016
    Location
    Lawrence KS
    MS-Off Ver
    2016
    Posts
    4

    Question listing array values in a dynamic list based on 2 criteria from ranges

    Brand new here, hopefully you guys can point me in the right direction. I have a list of items, 1 thru 12, that have a High or Low Profit and a High or Low Mix.

    I'd like to 'graph' these in a quadrant style layout depicting items in a dynamic list in the 4 possibilities of High-High, High-Low, Low-High, and Low-Low.

    I've tried index(small(if(row from http://www.exceltactics.com/make-fil...using-small/5/ and while that works great if i'm just testing for one criteria, it falls apart if i put an AND in there for testing both.

    I've tried Choose/Match from http://www.excelguru.ca/forums/showt...met-excel-2010 that it just doesn't look like that one will work for me.

    I'm sure i'm missing something small.

    I attached some pics of what i'm working with, hopefully it makes sense!

    thanks guys!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by lkeltner; 09-11-2016 at 03:59 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Listing Unique values based on partial match criteria
    By mamachrissy1028 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2016, 05:23 PM
  2. [SOLVED] Listing Unique values based on partial match criteria
    By mamachrissy1028 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2016, 11:38 AM
  3. Replies: 14
    Last Post: 11-30-2012, 02:54 PM
  4. Selecting two dynamic ranges and paste values only combining into one list
    By jbellows in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-27-2012, 05:36 PM
  5. Dynamic sumif ranges based on Hlookup criteria
    By Dial1 in forum Excel General
    Replies: 2
    Last Post: 10-24-2011, 01:21 AM
  6. Replies: 5
    Last Post: 10-29-2010, 09:35 PM
  7. Listing Specific Values Based on Criteria (Including Duplicates)
    By Jace in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2008, 02:57 PM

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