like name of column one is Tele other is Tele 2, if number in any columns it wouldn’t allow , any ideas please ?
sorry for my English im trying to prevent duplicate like this
number in column Tele is 01117111388 if it is also in Column Tele 2 which is 01117111388
it would not be valid ? any ideas
Solved! Go to Solution.
I wonder if this would do what you want done?
NOT(IN([_THIS], Clients[Tele 2]))
Hello, i was there before i post the problem and typed the code and thought it works but actually it didn’t would give me some tips ?
What did you try? In what way did it not do what you want?
NOT(IN([_THIS], SELECT(Users[User_Name], [UserID] <> [_ThisRow].[UserID])))
i used this one my sheet like this
NOT(IN([_THIS], SELECT(Clients [Tele 2], [Tele] <> [_ThisRow].[Tele])))
and it was accepted but the function didn’t work, i need as the following
if the number in [Tele] = [Tele 2 ] make it invalid
Where did you enter these expression? I would expect them to be used in Valid If. The first for the User_Name column of the Users table, the second for the Tele 2 column of the Clients table.
Can you provide screenshots?
I wonder if this would do what you want done?
NOT(IN([_THIS], Clients[Tele 2]))
well Sir thank you so much, i got the idea from the type of coding and in Tele i did same code as you typed
then i went to Tele 2 and typed it as NOT(IN([_THIS], Clients[Tele]))
and it WORKED!!
you made my day thank you so much
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |