+ Reply to Thread
Results 1 to 4 of 4

Filter Data, list cresults on top of box (for data validation)

  1. 07-20-2018, 09:39 AM #1
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Filter Data, list cresults on top of box (for data validation)

    Hi, what would be a way of going about this one, please? Screenshots and Excel attached. Thanking in advance!!

    https://www.excelforum.com/attachmen...1&d=1532093901 [EXCEL]

    2018-07-20_1532.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-20-2018, 09:44 AM #2
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Filter Data, list cresults on top of box (for data validation)

    Something like...
    In T1158: Confirmed as array (CTRL + SHIFT + ENTER)
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Copy down.
    Attached Files Attached Files
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  3. 07-20-2018, 12:12 PM #3
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Filter Data, list cresults on top of box (for data validation)

    It worked, perfectly!! Thank you, CK76, much appreciated.
    Reply With QuoteRegister To Reply
  4. 07-20-2018, 12:14 PM #4
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Filter Data, list cresults on top of box (for data validation)

    You are welcome and thanks for the rep
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filter using value from data validation drop down list
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2018, 09:49 PM
  2. Filter with data validation list
    By asad.ermo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2017, 03:07 AM
  3. Data validation list filter with range defined by OFFSET
    By Mango123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-14-2014, 07:20 AM
  4. Filtering Data Validation List Without Using Advanced Filter
    By idlewild in forum Excel General
    Replies: 3
    Last Post: 05-15-2011, 11:46 AM
  5. Filter Results Shown In Data Validation List
    By Spencer in forum Excel General
    Replies: 19
    Last Post: 03-15-2011, 05:15 AM
  6. Filter a data validation list from a table
    By JackyJ in forum Excel General
    Replies: 1
    Last Post: 08-19-2010, 06:47 AM
  7. Filter Data validation List
    By sakinen in forum Excel General
    Replies: 1
    Last Post: 07-05-2010, 08:03 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1