Forum Discussion
Nested IF formulas with OR statement
Stachu OwenAuger Thanks for your tips. For my original problem your solution helps.
However, I have run into another issue which is that the last item from ValueList ("H1") is never returned,because of its position at the end of the list.
The new problem is that :
I am trying to create 1 new column [Result] based on a two columns [X] and [Y]. Both columns [X] and [Y] have the same 8 distinct values (A1... H1).
If I filter for A1, I want it to return all rows where both [X] is A1 and [Y] is A1.
hmm, doesn't this approach require multiple values in a column?
say I have X,Y in following format
X|Y
A1|A1
A1|B1
so in this case the Result should be something like this (to properly filter B1):
Result
A1
A1,B1
I think in this case it's best to create separate table for the slicer with just A1:H1, and propagate filter to X & Y from there