+ Reply to Thread
Results 1 to 6 of 6

Data Validation Unique Value

  1. #1
    Forum Contributor
    Join Date
    10-22-2014
    Location
    Indonesia
    MS-Off Ver
    2010
    Posts
    177

    Data Validation Unique Value

    Hello,

    I need help to fix the formula related to data validation.
    I have a table, and i want create dropdown list ( data validation),

    Current one ( with yellow highlight) is the dropdown with offset function to make it dynamic,
    however, the data contain duplicate and not sort, try few formula to make it unique but not success yet.

    Attach is example of the sheet.

    Would be great if you guys can help me.

    Thank you very much.

  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: Data Validation Unique Value

    I think you forgot to attach the sheet?

    And what is the formula?
    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
    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: Data Validation Unique Value

    I think you forgot to attach the sheet?

    And what is the formula?

  4. #4
    Forum Contributor
    Join Date
    10-22-2014
    Location
    Indonesia
    MS-Off Ver
    2010
    Posts
    177

    Re: Data Validation Unique Value

    Hi,

    Apologies for late respond,

    Actually the problem solved, after trying some code from another thread:

    http://www.excelforum.com/showthread.php?t=664360

    to use Offset countif formula.

    Would you advise how to close this thread?

    Thank you.

  5. #5
    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: Data Validation Unique Value

    Thanks for the feedback, I will mark this as SOLVED for you.

    For future reference, you can use Thread Tools (located above your first post) and choose "Mark this thread as solved".
    Thanks.

  6. #6
    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: Data Validation Unique Value

    Thanks for the feedback, I will mark this as SOLVED for you.

    For future reference, you can use Thread Tools (located above your first post) and choose "Mark this thread as solved".
    Thanks.

+ 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. [SOLVED] Unique values in data validation
    By sureshpunna in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-26-2012, 05:59 AM
  2. Unique Data Validation
    By jeffbert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2006, 12:10 PM
  3. Data Validation dependant and unique
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 07:05 PM
  4. Data Validation dependant and unique
    By Sara Hopkins in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  5. [SOLVED] Data Validation dependant and unique
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-06-2005, 05:05 AM
  6. [SOLVED] Data Validation dependant and unique
    By Sara Hopkins in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Data Validation dependant and unique
    By Sara Hopkins in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. [SOLVED] Data Validation dependant and unique
    By Sara Hopkins in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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