Results 1 to 3 of 3

Thread: Trying to create filtered results in the second file or workbook

  1. #1

    Trying to create filtered results in the second file or workbook



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have two columns in Workbook 1 - "Issues" and "Regions" as below:

    Issues Regions
    1111 Eastern
    2222 Atlantic
    3333 Eastern
    5555 Midwestern
    6666 Eastern
    7777 Midwestern

    I'm trying to create the filtered results in the Second Workbook or file, with the same two columns, as below:

    Regions Issues
    Atlantic 2222
    Eastern 1111, 3333, 6666
    Midwestern 5555, 7777

    Could you help me with a formula to achieve this? Thanks!

  2. #2
    Can someone help me achieving this with a formula? Thanks.

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,491
    Articles
    0
    Excel Version
    Excel 2016


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •