Search code examples
listgoogle-sheetsfiltermatchunique

Filter once a value

In working with a formula in Google Sheets so basically I have list of repited institutions and their corresponding ID, like this:

enter image description here

I used this formula to extract the unique values of institutes:

`=IFERROR(INDEX(A2:A24,MATCH(0,INDEX(COUNTIF($C$1:C1,A2:A24),),0)),"")`

It gives me a list of the institutions only once, then I used this formula to do a filter for the ID of that institution:

=TRANSPOSE(IFERROR(FILTER($B$2:$B$24,$A$2:$A$24=D2,$B$2:$B$24<>""),""))

But it gives me a list of multiples times appearing that ID like this:

enter image description here

I would like to have just a list like this:

enter image description here

enter image description here

Solution

  • try this formula:

    =UNIQUE(A2:B)