Forum Discussion
Solved
Help With Filter Function
Hello All, I hope nothing too similar has been posted before, but I am struggling with a filter function. I have two sheets, One where data will be displayed to the end user, and a query th...
=FILTER(INDEX(HCData!A1:G50;SEQUENZ(ZEILEN(HCData!A1:G50));{4.7});(HCData!A1:A50=A13)*((HCData!C1:C50="Production Team Member")+(HCData!C1:C50="Production Temporary"));)
This formula works in my spreadsheet.
=FILTER(INDEX(HCData!A1:G50;SEQUENZ(ZEILEN(HCData!A1:G50));{4.7});(HCData!A1:A50=A13)*((HCData!C1:C50="Production Team Member")+(HCData!C1:C50="Production Temporary"));)
This formula works in my spreadsheet.
Would "SEQUENZ" be "SEQUENCE" and "ZEILEN" be "ROWS"? That is what I'm guessing based on google.... I don't have either of those exact functions.
I am also getting an error at "(INDEX(HCData!A1:G50;"
I am also getting an error at "(INDEX(HCData!A1:G50;"