Forum Discussion
sruk89
Dec 06, 2024Brass Contributor
** 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 & "...
sruk89
Dec 10, 2024Brass Contributor
hopefully this will be a bit clearer HansVogelaar
B243 = Test - do not remove
M243 = Y (UK)
N243 = Q1'25
O243 = Y (IT)
P243 = Q2'25
Id expect to returned in formula 1 "Test - do not remove UK" as this formula is looking for Q1'25 values in formula 2 id expect to see "Test - do not remove IT" as this is looking for Q2'25 values
Here is an example of what i'd like to see with my simplified logic
=TEXTJOIN("; ", TRUE,
FILTER(
Catalogue!$B$3:$B$987 &
IF(Catalogue!$N$3:$N$987 = E$1, " UK", "") &
IF(Catalogue!$P$3:$P$987 = E$1, " IT", ""),
(Catalogue!$A$3:$A$987 = $D$1) *
(Catalogue!$C$3:$C$987 = $D2)
),
"None"
)