This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

I would like to know how to prevent duplicate numbers in two columns

Posted on 07-14-2021 05:44 AM
111182
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

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 Solved
0 8 193
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to 111182
Reply posted on --/--/---- --:-- AM

I wonder if this would do what you want done?

NOT(IN([_THIS], Clients[Tele 2]))

View solution in original post

Jump to Solution
8 REPLIES 8
Top Labels in this Space