Results 1 to 2 of 2

Thread: sorting/filtering automatisation

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Nov 2017
    Posts
    21

    Exclamation sorting/filtering automatisation

    Hello everyone,

    I have spent quite a lot of time trying to figure this one out.

    I have excel with bunch of data, and I need to show data which is based on filtering. I need to, based on one data column, show filtered content of another column.
    I can do this manually, but data source is dynamic, so I need a formula or macro for this thing...

    One idea would be to represent unique elements of column 1, and then somehow filter column 2 based on content of column 1.



    To make it simpler, here is a screenshot of what I am trying to do...

    Name:  123.jpg
Views: 146
Size:  23.0 KB

  2. #2
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,574

    Re: sorting/filtering automatisation

    See if the attached works for you. You may need to change some column references, depending on where your data is.
    Attached Files Attached Files

Posting Permissions

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



Click Here to Expand Forum to Full Width