+ Reply to Thread
Results 1 to 2 of 2

Group columns / Filter for multiple values

  1. #1
    Registered User
    Join Date
    08-31-2020
    Location
    Stuttgart, Germany
    MS-Off Ver
    2013
    Posts
    1

    Group columns / Filter for multiple values

    Hi,

    for work I need an Excel sheet with a pivot table where you can filter for different packetes and see which processes includes the packet.
    It's linke that:
    Process Packet 1 Packet 2 Packet 3
    Pr1 1 1
    Pr2 1 1

    1 means that it includes the packet.
    Has anyone an idea or another way for a solution?

    Thanks
    p.s. I'm sorry if this topic is already discussed, but I didn't know how to search for this problem.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,554

    Re: Group columns / Filter for multiple values

    Hello phillopp and Welcome to Excel Forum.
    Please utilize the instructions in the banner at the top of the page to upload an .xlsx file that shows the setup of the raw data (I am assuming that what is shown in post #1 is the desired layout of the the pivot table).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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 multiple columns, duplicate values
    By kenp94 in forum Excel General
    Replies: 6
    Last Post: 03-22-2018, 12:04 PM
  2. Extract data from multiple columns, group and sum up unique values
    By Alcotraz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2015, 06:54 PM
  3. Replies: 2
    Last Post: 02-04-2014, 03:33 PM
  4. [SOLVED] Group/sort rows based on values in multiple columns?
    By teitoku in forum Excel General
    Replies: 5
    Last Post: 08-07-2012, 02:20 PM
  5. Filter rows based on cell values in multiple columns
    By dionaqld1 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-25-2012, 09:13 AM
  6. Auto filter and fill values in multiple columns
    By learningkid0808 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2011, 06:52 AM
  7. Filter based on values of multiple columns
    By learning in forum Excel General
    Replies: 8
    Last Post: 09-29-2009, 03:17 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1