+ Reply to Thread
Results 1 to 6 of 6

Filter Data Based on What's Selected

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Filter Data Based on What's Selected

    Hi guys, facing some mistery here, if would be okay to ask you take a look.

    I'm using this formula =OFFSET($B$8:$B$10,0,MATCH(G3,$C$7:$E$16,0)) to help filter data in H3 based on what is selected in G3. This formula works perfectly in another file I grabbed it from but it does not work in a file I'm trying to replicate in the exact same way? Out of ideas, and frustrated...

    Any suggestions? No arrays please.

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

    2019-06-05_1511.png
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Filter Data Based on What's Selected

    Your match range is off. It should be $C$7:$E$7 not $C$7:$E$16.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Filter Data Based on What's Selected

    Thanks, that's not what I have in another example that works...

    But I have just tried your suggestion and it pulls up only top 3 results from a selected category, row 8 to 10 instead of 8 to 16?

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Filter Data Based on What's Selected

    Change $B$8:$B$10 to $B$8:$B$16.

  5. #5
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Filter Data Based on What's Selected

    Ou, so that was a buggar. Worked, thank you!!!!

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Filter Data Based on What's Selected

    You are welcome and thank for the rep

+ 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. filter data based on text entered or selected
    By lee2121 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2016, 05:43 AM
  2. Filter the data accroding to items selected
    By Shermaine2010 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-12-2014, 02:21 AM
  3. [SOLVED] Filter based on selected range
    By forfiett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2013, 05:38 PM
  4. Compare 2 worksheets based on a selected filter
    By oxmanonline in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2013, 08:29 AM
  5. [SOLVED] Macro To Filter Dates Based On Data In Selected Cell
    By SilverFox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2012, 08:45 AM
  6. [SOLVED] Move data from SHEET1 to SHEET2 based on Selected criteria...like an adv filter
    By gspivey79 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-03-2012, 02:06 PM
  7. Filter Data on Multiple Tabs based on Selected Data
    By MAshleigh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2012, 02:17 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1