0

Consider the following table :

Test Name  Bug name  Status
Name1            Bug1        Fail
Name2            Bug1        Fail
Name3            Bug2        Fail
Name4            Bug3        Fail
Name5            Bug4        Fail
Name6            Bug3        Fail

I want to be able, on a given Google spreadsheet to select all rows containing distinct 'Bug name' columns, so the result should be the following :

Test Name  Bug name  Status
Name1            Bug1        Fail
Name3            Bug2        Fail
Name4            Bug3        Fail
Name5            Bug4        Fail

confile
  • 30,949
  • 47
  • 199
  • 357
Ohad Benita
  • 493
  • 1
  • 7
  • 20

1 Answers1

2

Assuming you have the example table in range A1:C, I think the expected result could be achieved with this formula:

=ArrayFormula(iferror(vlookup(unique(B1:B),{B1:B,A1:C}, {2,3,4}, 0 )))

See if that helps ?

JPV
  • 25,196
  • 4
  • 30
  • 48