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...
One more option is PivotTable with measure
Sources:=CONCATENATEX( DISTINCT( Table1[Source] ), Table1[Source], ", " )which gives
Depends on Excel version. But since nobody knows on which Excel version/platform your are, other suggested solutions as well could work, could not work.