+ Reply to Thread
Results 1 to 2 of 2

how to ignore blank cells in creatig dropdown lists (validation lists)

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    Denmark
    MS-Off Ver
    O365
    Posts
    249

    how to ignore blank cells in creatig dropdown lists (validation lists)

    I am trying to make a drop down list (validation list) where my data source is from another sheet. I was able to do it successfully but the problem is the blank cells are also being included. I also put a check mark in "ignore black" in validation settings but still getting the same results. I also tried merging the cells - also same results.

    Any suggestions so everytime the dropdown list will show, only cells with texts are shown (blank cells are not included)?
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,756

    Re: how to ignore blank cells in creatig dropdown lists (validation lists)

    You could put a separate list of the items in Column A, say starting at X3, like this:

    Material/tools/equipments
    Process
    Documentation
    Offshore infrastructure
    Personal
    Site infrastructure

    Then use this as the source for your DV drop-down.

    Hope this helps.

    Pete

+ 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