Forum Discussion
How to find a specific number from 2 columns
Source number Wanted outcome Question: a 1 Number is only from source a I like to know from what source is the number coming from? a 1 Number is from source a and b Is it alone from...
This is a 365 insider beta solution to the problem, so irrelevant to most!
= LET(
nums, UNIQUE(number),
src, MAP(nums,
LAMBDA(n,
TEXTJOIN(", ",, UNIQUE(FILTER(source, number=n)))
)
),
CHOOSE({1,2}, nums, src)
)