Results 1 to 2 of 2

Thread: Displaying the value/data that was filtered

  1. #1

    Displaying the value/data that was filtered



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

    Hello...How do I automatically display to another sheet (or column) the data that was filtered?

    Let's say I have this:

    A▼
    3
    1
    2
    1
    3
    2
    1

    If I'll filter it to show only 3, how can I make that filtered data (3) to show in another column of sheet? Thanks in advance.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    see attached.
    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
  •