Results 1 to 4 of 4

Thread: How to find the Active Members

  1. #1

    Smile How to find the Active Members

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

    Good afternoon!

    My first post, hopefully I don't mess it up :-)

    I am looking to filter some data in my file. I figured out I need 2 filters

    1. A filter that only shows me unique data (This column shows a lot of similar transaction ID's). I found the advanced filter tool for this.
    2. A filter that shows me the successful transactions (Status = Success). I found the standard filter tool for this.

    My question: As soon as I try to start step 2, the advanced filter (including results) disappears.

    Is there a way to run both filters as the same time?

    Thank you

  2. #2

    You could use a helper column to supplement the table and use two standard filters. Something like:

    = if( countif($A$1:A1 , A1) > 1, 0, 1) in B1 and drag down. This will give you a "1" in each unique line and a "0" in all duplicates. You can then filter on the 1's. **Note, it is important that only the first part of the range is an absolute reference**

    Hope this helps. Best of luck,

  3. #3
    That's an excellent idea! Thank you!

  4. #4
    Thanks . You're very welcome.

Posting Permissions

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