Results 1 to 7 of 7

How to show values less than or equal to another value in drop down list, data validation

Threaded View

emily31 How to show values less than... 10-31-2013, 06:37 AM
Ace_XL Re: How to show values less... 10-31-2013, 07:03 AM
martindwilson Re: How to show values less... 10-31-2013, 07:21 AM
emily31 Re: How to show values less... 10-31-2013, 10:58 AM
martindwilson Re: How to show values less... 10-31-2013, 03:02 PM
emily31 Re: How to show values less... 11-01-2013, 04:06 PM
emily31 Re: How to show values less... 11-01-2013, 06:25 PM
  1. #1
    Registered User
    Join Date
    10-31-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    4

    Unhappy How to show values less than or equal to another value in drop down list, data validation

    Hello,

    I have a problem where I want to show in a drop down list only the names that refer to values that are less than or equal to a separate value. I would be able to do this using data validation but I'm not sure how to go about it.

    I have included a spreadsheet with the number of marbles and four bags with different capacities. In the drop down list, I would like to only show the number of the bags that the marbles will fit in. For example, if there were 200 marbles then the drop down list would only show 2 and 3 as the capacity of bag 2 and 3 are larger than the number of marbles.

    Thank you for your help in advance!

    emily31
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to display list of values in cells after using data validation drop down?
    By Yadhvi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-03-2013, 12:15 PM
  2. Data Validation Drop Down Boxes (List) - Values Keep Duplicating
    By CJoQ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2012, 05:07 AM
  3. Replies: 6
    Last Post: 06-07-2012, 02:28 PM
  4. Replies: 4
    Last Post: 06-07-2012, 10:04 AM
  5. [SOLVED] Can we change font size of values in validation drop down list?
    By linda in forum Excel General
    Replies: 2
    Last Post: 11-17-2005, 04:15 PM

Tags for this Thread

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