Forum Discussion

sruk89's avatar
sruk89
Brass Contributor
Dec 06, 2024

** Help ** Need to filter same result but in different formulas dependent on Quarter

Hi  HansVogelaar  I need help modify my formula/logic (request below) Formula 1 =TEXTJOIN("; ", TRUE,     FILTER(         Catalogue!$B$3:$B$987 &         IF((Catalogue!$L$3:$L$987 = E$1 & "...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Dec 06, 2024

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

  • sruk89's avatar
    sruk89
    Brass Contributor
    Dec 09, 2024

    Thanks HansVogelaar - I have sent you a direct message with a scrubbed version.

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Dec 09, 2024

      It's this part:

                  IF(TRUE,
                IF(Catalogue!$M$3:$M$987 = "Y", " UK", "") &
                IF(Catalogue!$O$3:$O$987 = "Y", " IT", "") &
                IF(Catalogue!$Q$3:$Q$987 = "Y", " DE", ""),
            ""),

      In Catalogue row 243, both M243 and O243 are "Y", so you concatenate "UK" and "IT". You do not check if each of the columns next to it contain Q1'25

      • sruk89's avatar
        sruk89
        Brass Contributor
        Dec 10, 2024

        thanks HansVogelaar - could you help me with this? As this is the part that im struggling with

Resources