Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two columns, [Customer 1] and [Customer 2], they share 4 of the same members; 'Member A', 'Member B', 'Member C', and 'Member D'.
I have multiple charts on my sheet, some pertain to [Customer 1], some to [Customer 2].
Using a Filter Pane, I am trying to create a formula that shows only the 4 common members (A-D) and when one is selected, the filter applies to both [Customer 1] and [Customer 2].
Please help!
I'd probably agree with @rbartley. But this should give you what you want: this will only show where values exist in both customer fields and selects the value in both fields:
=aggr(if([Customer 1] = [Customer 2], [Customer 1] ), [Customer 1] , [Customer 2])