+ Reply to Thread
Results 1 to 8 of 8

data validation without empty cells

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    data validation without empty cells

    Hi everyone.
    In the attached workbook in B2 "grafici" sheet there is a data validation define name = mese.
    Is it possible to remove the empty cells from the list?
    max
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: data validation without empty cells

    The cells are not empty, they have formulas in them.

    I suppose you could find the last row in Column N and use that as the last row in column B

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: data validation without empty cells

    Hi in web I found this formula

    Please Login or Register  to view this content.
    but does not remove empty cells

  4. #4
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: data validation without empty cells

    Davesexcel In the web I found

    Please Login or Register  to view this content.
    does it work, someone has better?
    Attached Files Attached Files

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: data validation without empty cells

    Yes, your formula works for me.

    Can you clarify why you are asking if it works, when clearly it does?

  6. #6
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: data validation without empty cells

    To see if there are other formulas to get the same result
    max

  7. #7
    Forum Contributor
    Join Date
    12-13-2013
    Location
    Calgary,AB,Canada
    MS-Off Ver
    2016,O365
    Posts
    236

    Re: data validation without empty cells

    =offset(n2,,,24-countif(n2:n25,""),1)

    or

    =OFFSET(N2,,,COUNTA(N:N)-1,1)

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: data validation without empty cells

    Not prepared to help until you start marking your threads as SOLVED...
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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: 0
    Last Post: 02-28-2014, 04:55 PM
  2. Exclude Empty Cells in a Data Validation List
    By skip2mylew in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-22-2013, 07:05 PM
  3. [SOLVED] Empty Cells if Not Pass the Validation
    By Resant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2006, 01:45 AM
  4. [SOLVED] Data validation and empty cells
    By Kris in forum Excel General
    Replies: 3
    Last Post: 12-19-2005, 06:45 PM
  5. [SOLVED] Data validation and empty cells
    By Kris in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2005, 06:25 PM
  6. Data Validation and Empty Row
    By mzafar in forum Excel General
    Replies: 1
    Last Post: 07-19-2005, 10:36 AM
  7. Empty Cells in validation List
    By Jasper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2005, 10:06 AM
  8. [SOLVED] Empty Cells in validation List
    By Jasper in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-24-2005, 09:12 AM

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