+ Reply to Thread
Results 1 to 10 of 10

Need help with Data validation function

  1. #1
    Forum Contributor
    Join Date
    07-01-2019
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    179

    Smile Need help with Data validation function

    Hi,


    Please see attached workbook with the formulas and the data validation with drop down list.

    The problem is that I am trying to make a drop down list from 2 different columns.
    They have different filter functions and one of them is working, the other one is returning an error.

    I am not sure what I am doing wrong, what is wrong and how to solve it.


    Kind regards
    Kristian
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need help with Data validation function

    Rather than tell us what is or isnt working, explain what you are trying to do.
    (neither of your DV cells work for me anyway)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    07-01-2019
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    179

    Re: Need help with Data validation function

    I am sorry.

    This is part of a huge workbook, that's why it's only 0s.

    I simply want to make a drop down list from column K10. I would like to use the spill function (#) so the list will cover the entire array as it may change in size.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Need help with Data validation function

    If you want to use col K try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-01-2019
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    179

    Re: Need help with Data validation function

    Thank you very much. That works very well!


    This drop down list is now returning a lot of dates in different order.
    Is it possible to get the result in ascending order?

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Need help with Data validation function

    You will either need to change the formula in H10 or you will need a helper cell.

  7. #7
    Forum Contributor
    Join Date
    07-01-2019
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    179

    Re: Need help with Data validation function

    Ok.

    So it's not possible to put the sort formula together with the index formula in the Data validation box?

    The array H:Q is already sorting column 4. I am using this in another calculation.

    How could I solve it with a helper cell?

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Need help with Data validation function

    The array H:Q is already sorting column 4.
    In that case col K will already be sorted as it's the 4th column in the array

  9. #9
    Forum Contributor
    Join Date
    07-01-2019
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    179

    Re: Need help with Data validation function

    I have made a mistake here.
    It's not col K I need to use, it's J.

    The ascending order of the dates I have in column K is used for one purpose.
    And I need to use the dates I have in column J, the third column for another purpose.
    And it will not be possible to sort borth columns at the same time.

  10. #10
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Need help with Data validation function

    In that case create a helper column using
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Function of function of cell reference in data validation.
    By Borkar2018 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2018, 04:27 AM
  2. [SOLVED] Data Validation using OR Function
    By Pool in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-31-2016, 11:04 AM
  3. [SOLVED] Data Validation IF function
    By rviji.cbe in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-27-2015, 09:17 PM
  4. Replies: 0
    Last Post: 10-03-2013, 02:02 AM
  5. IF Function & Data Validation
    By oceans11 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2011, 11:51 PM
  6. Function in data validation that keeps user from entering duplicate data?
    By comptechbranden in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2007, 05:31 AM
  7. Data Validation Function Help
    By John Jost in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-22-2005, 11:30 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