Filtering data from a non-continuous list

Discussion in 'Excel' started by Pablo Lionco, Jul 3, 2018.

  1. Pablo Lionco

    Pablo Lionco

    Joined:
    Jul 3, 2018
    Messages:
    2
    Likes Received:
    0
    Hello everyone!

    I'm stuck with what seems to be a very simple task, although I'm not familiar with. I have seen similar questions asked, but have not found a proper solution.
    I have a budget proposal which has multiple sections that need to be filtered considering the nature of the expense (priority, new and continuous expense).
    I need to filter data, but the title sections which determine the nature of the expenses (1-consumable, 2- software and harware and 3 -outsourcing) do not allow filtering, since they are breaking data flow.

    Spreadsheet is attached to this message.

    Any help would be greatly appreciated!
     

    Attached Files:

    Pablo Lionco, Jul 3, 2018
    #1
    1. Advertisements

  2. Pablo Lionco

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    65
    Likes Received:
    5
    You can do this by selecting the cells you want to apply the filter to and then applying the filter. However, given you have merged cells and subtotals this is unlikely to work well.
     
    Becky, Jul 4, 2018
    #2
    1. Advertisements

  3. Pablo Lionco

    Pablo Lionco

    Joined:
    Jul 3, 2018
    Messages:
    2
    Likes Received:
    0
    Thanks for your reply, Becky! Any other suggestion? I thought of breaking the spreadsheet into multiple tabs, taking into account the diverse nature of the expenses, and then grouping them together into a final report.

    But I have no clue on how to proceed...
     
    Pablo Lionco, Jul 4, 2018
    #3
  4. Pablo Lionco

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    65
    Likes Received:
    5
    I think splitting it across multiple tabs is a good idea. You could then have a final sheet which links to the cells from the other sheets.
     
    Becky, Jul 5, 2018
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.