+ Reply to Thread
Results 1 to 4 of 4

Data validation list. Less than, greater than?

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    Mn
    MS-Off Ver
    Excel 2010
    Posts
    2

    Data validation list. Less than, greater than?

    I've been searching high and low but have been unable to find a solution. Part of my spreadsheet has columns setup as dynamic ranges (price,desc,sku,price_desc). What I am trying to do is setup 2 data validation lists, 1 with the items less than $35 and the other with items great than or equal to $35 and the text that I want in the list is from the price_desc range. No matter what I try I can't make this happen. If anyone has input I would greatly appreciate it!

    Thanks,
    Adam

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Data validation list. Less than, greater than?

    You would have to create 2 new lists, one for each price level, then use these new lists for the source of the drop down lists.

    If you can post a SMALL sample file I can show you how to do it.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    05-21-2013
    Location
    Mn
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Data validation list. Less than, greater than?

    Thanks for the quick reply. If I need to create 1 list per price level I can handle that...I was just hoping to avoid doing so. Thanks again for your help.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Data validation list. Less than, greater than?

    Good deal. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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