+ Reply to Thread
Results 1 to 2 of 2

Show every other entry in a data validation list?

  1. #1
    Forum Contributor
    Join Date
    05-30-2011
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    107

    Show every other entry in a data validation list?

    I have a long list of items. Each other line has text while each othr line is empty.

    I want to use this as a data validation list and leave out the empty lines. What is my best option?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Show every other entry in a data validation list?

    Use a helper column to load the data without blanks and refer it in DV range


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 12-19-2013, 10:44 AM
  2. Replies: 4
    Last Post: 06-30-2013, 09:37 AM
  3. Replies: 0
    Last Post: 10-06-2011, 07:03 AM
  4. Data Validation - List OR Any entry
    By Lassie in forum Excel General
    Replies: 1
    Last Post: 01-01-2011, 11:36 PM
  5. Data Validation > List > Default Entry?
    By BuRn3R in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2009, 06:49 PM

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