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.
Bookmarks