I would like to make a column that returns a list of values of the column [Teammembers] of orders they had from the column [order]
So the column returns for example: for Order 1: teammember 1, teammember 3 for Order 2: teammember 2, teammember 3,โฆ
What would be a good formula? Can this also in an fysical column? Not a virtual column?
Bram
physical
Team members with order 1:
=SELECT(MyTable[teammember], ([order] = โOrder 1โ))
Team members with order 2:
=SELECT(MyTable[teammember], ([order] = โOrder 2โ))
Youโd probably want this yo be a virtual column.
Thanks Steve, An additional question: you have an idea how to get unique values for [teammember]?
So when Stephano has 2 times Order 2 in the tabel I get his name only 1 time in the list?
in google sheets it would be Sort(unique(SELECT(MyTable[teammember], ([order] = โOrder 2โ))))
thx a lot, Bram
Try subtracting an empty list:
SELECT(MyTable[teammember], ([order] = โOrder 2โ)) - LIST()
In fact, any list subtraction will remove duplicates from a list. Iโm not sure this is โsupportedโ behavior, so it might change in the future, but for the time-being, itโs the only option Iโm aware of.
Thx Steve
โฆ thatโs working!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |