0

I am trying to sort out a spreadsheet which has multiple columns in but don't really know where to start!

I am looking to filter the sheet where column C has more than 3 errors for the ID on column B.

Where it finds a result like this I need it to show all of the data, hopefully the screenshot below helps explain what I am trying to do!

Showing how I would like it to respond

1
  • Consider sharing a publicly editable sample spreadsheet with realistic-looking data, and showing your hand-entered expected results there. May 6 at 13:05
0

This can be done by first locating the IDs with three errors or more, and then filtering the data by those IDs. Try this:

=sort( 
  filter( 
    A2:B, 
    match( 
      A2:A, 
      query( 
        query(A2:B, "select A, count(B) where A is not null group by A", 0), 
        "select Col1 where Col2 >= 3", 
        0 
      ), 
      0 
    ) 
  ), 
  1, true, 2, true 
)
1
  • Thank you so much! This worked flawlessly for me. May 6 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.