Forum Discussion

rttmmwv's avatar
rttmmwv
Copper Contributor
Feb 05, 2022
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...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 05, 2022

    rttmmwv 

    =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.

harshulz's avatar
harshulz
Iron Contributor
Feb 05, 2022
you trying to say you have two excel sheets
one the filtered one you have to present to end user with the following queries? ryt?
  • rttmmwv's avatar
    rttmmwv
    Copper Contributor
    Feb 07, 2022

    harshulz Yes, that's correct. I have a query on one sheet and will be filtering that data on the sheet presented to end users. 

Resources