Is it possible to get multiple columns to CONCATENATE into a column that is a ref with a select formula for values?
My current suggested values formula is Select(Serial List[Serial #], [Company Name]=[Serial #1].[Company Name]).
Could I anyway get multiple columns on that suggested formula list?
Expression Example,
Select(
Serial List[Serial #],
AND(
[Company Name] = [Serial #1].[Company Name],
[Column2] = [Serial #1].[Column2],
[Column3] = [Serial #1].[Column3]
)
)
That seems close, basically I want it to display multiple columns in the lookup.
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |