+ Reply to Thread
Results 1 to 6 of 6

Return results based on selections

  1. #1
    Registered User
    Join Date
    05-15-2020
    Location
    Birmingham, England
    MS-Off Ver
    Microsoft 365
    Posts
    3

    Return results based on selections

    Hi,

    I am trying to return results based on a user's selection (maybe a tickbox selection). I have attached a sample file.

    I want to be able to filter a list of content from my inventory.

    1. If I only have box 1, then only return contents results where box 1 appears (lines 2-4)
    2. If I only have box 2, then only return contents results where box 2 appears (lines 5-7)
    3. If I have both boxes, then return all results

    I tried doing this with pivot and slicers but I couldn't get option 3 to work properly.

    What is the best way of doing this please?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,437

    Re: Return results based on selections

    With a pivot table.

    you can select the columnlable for the criteria (1 , 2, 1 and 2)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-15-2020
    Location
    Birmingham, England
    MS-Off Ver
    Microsoft 365
    Posts
    3

    Re: Return results based on selections

    Hi,

    Thanks for the reply, I am not sure if this will do what I need. Apologies if my post wasn't clear.

    What I am looking for is that someone can open the file, tick the boxes they own (via the tickboxes(or some other method)). The content list will update accordingly.
    I tried with slicers before, which is good, but if I had a slicer for column b and c, and both were selected, then I would only see results on lines 8-11 (as they combine the contents of both boxes). Instead, this should return all results.

    Thanks,

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,437

    Re: Return results based on selections

    If you don't use the slicer you can do it like I showed.

    Just tick in the columnlable on the expected criteria.

    The advantice of a pivot table is you only have to refresh the data.=> data => refresh => refresh

  5. #5
    Registered User
    Join Date
    05-15-2020
    Location
    Birmingham, England
    MS-Off Ver
    Microsoft 365
    Posts
    3

    Re: Return results based on selections

    With your spreadsheet, if I select Box 1 from the dropdown in your pivot table (column H), it shows content 10 for instance. This should be invalid as I would need both box 1 and box 2 for content 10.

    Regards,

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,437

    Re: Return results based on selections

    This should be invalid as I would need both box 1 and box 2 for content 10.
    The reason is the data was not in the table (column A and B).

    See the attached file (the green cells) for the adjustment and the result.

+ 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. COUNTIFS Does not Return Results for UK based users
    By SDillon in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-18-2020, 10:15 AM
  2. Lookup 2 values and return results based on these
    By Philly500 in forum Excel General
    Replies: 4
    Last Post: 08-26-2015, 07:02 AM
  3. Replies: 8
    Last Post: 03-11-2015, 08:33 PM
  4. [SOLVED] Formula for different options to return a value based upon the selections.
    By jleal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2014, 04:18 PM
  5. Return Results Based on Date Range
    By ExcelSuduko in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-05-2013, 11:23 AM
  6. Return Values From 2 Columns Based On Selections From 2 Comboboxes
    By Joe-XT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2013, 03:23 PM
  7. Return results based on multiple criteria
    By Bryce in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2005, 08: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