+ Reply to Thread
Results 1 to 2 of 2

Help identify position on graph

  1. #1
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    Help identify position on graph

    Hello All,
    On the attached, you will see I have 10 customers listed with a Gross List Price value and a discount value. On the second sheet ("parameters"), you will see that I have three measures that correspond to the discount level (Out of Bounds, Left fairway, and Right Fairway) and also a Gross List Price Value.
    Here is what I am after-
    I need to come up with a way to identify where these values would plot on a graph for each of my 10 customers. For instance, Applied Materials has a Gross List Price of 81M and a discount of 96%, if I switch over to my "parameters" worksheet, I would see that this customer would be plotted as "Out of Bounds" since the Gross List Price is over 10M and the discount is 96%. Is there a way to do this with a formula rather than the way I have been doing it manually?

    Any and all help is greatly appreciated!
    Thanks!
    Andrew
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Help identify position on graph

    In your sample, all but the last row of the table can be deleted, as NONE of the values are less than 10M. However, assuming that some can, on occasion, be less than 10 M...

    =IFERROR(INDEX(Parameters!$A$1:$C$1,MATCH(1,--(INDEX(Parameters!$A:$C,MATCH(C2,Parameters!$D:$D,1),)< Sheet1!B2),0)),"Out of Scope")

    However, even that doesn't cover 3 sets of values that are NOT covered by your definition.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. fix the position of a text box in an x-y graph
    By mverduyn in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-23-2020, 10:05 AM
  2. Position of graph affects performance
    By esskaykay in forum Excel General
    Replies: 1
    Last Post: 09-28-2020, 01:16 PM
  3. [SOLVED] hello, please identify in each vertical position the three patterns always the last * draw
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-13-2018, 10:27 AM
  4. [SOLVED] Help excel = identify the same even / odd pattern in the same position.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2018, 04:06 PM
  5. Identify by position the number of a draw list.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2017, 04:51 AM
  6. Replies: 0
    Last Post: 10-03-2014, 07:51 AM
  7. Identify Change in Grade or Position - Loop
    By ronanm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2011, 09:23 AM

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