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.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
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.

rttmmwv's avatar
rttmmwv
Copper Contributor
Feb 07, 2022
Sorry, I realized the error was coming from using semi-colon instead of comma. The Formula isn't giving errors now, but I'm getting "0" as the sole result.
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Feb 07, 2022

    rttmmwv 

    The formula returns the values from columns 4 and 7 of sheet "HCData". I deleted all the data in column 4 (Name) of sheet "HCData" and the formula returns only "0" for this column as you can see in the attached file. Maybe this is what happens in your file.

    • rttmmwv's avatar
      rttmmwv
      Copper Contributor
      Feb 07, 2022
      I tried with different columns and they're all returning 0. All of my columns have a few thousand rows of data, so there shouldn't be any blanks.
      • OliverScheurich's avatar
        OliverScheurich
        Gold Contributor
        Feb 07, 2022

        rttmmwv 

        Can you attach a file without sensitive data which shows the details that you can see in my attached files?

Resources