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