Home > Mobile >  Google Sheet Filter - exclude the first match associated to a column
Google Sheet Filter - exclude the first match associated to a column

Time:07-24

I have this Google Sheet that I ran a Filter in E2 to show all other stock-id's associated with each ID (in column A). What I want to achieve is to exclude in the result the data in the 1st match (in column F) because that is already in the stock-id column. I am using this formula FILTER(E1:E,A1:A=A2) that I just Transpose.

enter image description here

  • Related