Forum Discussion

PORTUGAL1524's avatar
PORTUGAL1524
Copper Contributor
Sep 19, 2023

PROBLEMS WITH THE FILTER FUNCTION

 
Hello everyone, I need help with my filter formula, I'm trying to use it to improve some demands here at the company, the formula is working fine but when it reaches the last criterion that searches for the name of the carrier it returns "#N/A ", this last criterion the column contains 12 different values ​​such as "GRT", "CRO", "FIT", "PTS", which are carrier acronyms.

=ESCOLHERCOLS(FILTRO('ACOMPANHAMENTO DE ENTREGA.xlsx'!Tabela1[#Dados];('ACOMPANHAMENTO DE ENTREGA.xlsx'!Tabela1[GRUPO ORGANIZADO]="ASSAI ATACADISTA")*('ACOMPANHAMENTO DE ENTREGA.xlsx'!Tabela1[[ DATA PRÓ ATIVO]]="")*('ACOMPANHAMENTO DE ENTREGA.xlsx'!Tabela1[[ DATA DA AGENDA]]>HOJE())*('ACOMPANHAMENTO DE ENTREGA.xlsx'!Tabela1[SIGLA]="GRT"));15;6;11;57;16;29;30;32) 

excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Sep 19, 2023

    PORTUGAL1524 

    I may have to see your sheet. It could be a problem with how the text is entered (Possibly some spaces after the string, etc.)

     

    This is a scaled-down re-creation of your data with a formula solution:

     

    =LET(
    filtered, FILTER(
        Table1,
        (Table1[Organized Group] = "ASSAI") *
            (Table1[Proactive Date] = "") *
            (Table1[Agenda Date] > TODAY()) *
            (Table1[GLA] = "GRT"),
        ""
    ),
    CHOOSECOLS(filtered, {1, 6, 9})
)

     

Resources