Results 1 to 3 of 3

Inter-related Data Validation and Referencing "weighted" percentages

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Inter-related Data Validation and Referencing "weighted" percentages

    So I am currently using 2 cells to set up a "range"

    Anything above A2 is the upper limit, anything below A3 is the lower limit, and anything between, is well...in between. I currently have them working off of lists, but the user can still select values greater or less than the incorrect cell. My real goal is to allow the user to select any integers they desire (greater than 0 and less than 100 probably)

    I want to make it so A2 must always be above A3, and the error message references the value in the other cell somehow. Is this possible? I can think of a work-around that removes a lot of my flexibility, by simply referencing one single value, and taking that difference from the top and bottom (it's how it is used most of the time, but not always).



    Final question, I was trying to have it do weighted percentages. Percentages weighted against the values it was pulling against, so in a list of 12, and i want the top 33%, it would return the highest 4 values.
    I finally came up with the logic for it so it is SOLVED see the attachment.

    I am still stuck on if/how you can reference another value with data validation. Unsure if possible. Will continue toying around with it.
    Attached Files Attached Files
    Last edited by TheN; 08-23-2016 at 05:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Double, conditional data validation. Related to each other.
    By Arnodekkers1995 in forum Excel General
    Replies: 2
    Last Post: 05-06-2016, 10:43 AM
  2. [SOLVED] Dynamic data validation to determine the SUM related output?
    By SChalaev in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2013, 02:15 AM
  3. Replies: 3
    Last Post: 05-28-2013, 10:23 PM
  4. Inter-related references ?
    By theta in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-14-2010, 11:21 AM
  5. Inter-related cells
    By sk1 in forum Excel - New Users/Basics
    Replies: 18
    Last Post: 01-06-2009, 07:05 AM
  6. [SOLVED] How does one sort a block of inter-related information in Excel?
    By jets in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2006, 12:20 AM
  7. [SOLVED] Inter-spreadsheet Referencing - Continual need to locate linked fi
    By Atreides in forum Excel General
    Replies: 0
    Last Post: 02-22-2005, 03:06 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