Hi, I'm not really good at this, and whatever I've tried doesn't seem to have worked so far. I'm trying to make a unique list or an OR() list from a few SELECT() generated lists in a data validity expression. This is what I'm trying to combine.
SELECT(table1[Name], [Name]<>[_thisrow].[Sender]),
SELECT(table1[Name], [Supervisor]=[_thisrow].[Sender]),
SELECT(table1[Manager], [Name]=[_thisrow].[Sender])
Each of these work individually, but I can't figure out how to put them together.
Any insight would be appreciated
Solved! Go to Solution.
SELECT( ... ) + SELECT( ... ) + SELECT( ... )
SELECT( ... ) + SELECT( ... ) + SELECT( ... )
I don't believe this, spent 2 hours trying to figure it out and the answer was so simple! Thanks! @Joseph_Seddik
User | Count |
---|---|
25 | |
25 | |
25 | |
23 | |
16 |