Results 1 to 2 of 2
  1. #1

    Thread Starter
    Junior Member
    Join Date
    Nov 2017

    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: 70
Size:  23.0 KB

  2. #2
    Join Date
    Oct 2008
    Midwest Region, United States

    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.