Hello Friends,
I am struggling with one of the issue where I need to write a formula which should able to determine the repeating same TIN numbers in a column. If the number is identical and repeated more than once, then the formula should be able to pick and validate it as "Invalid" else "Valid"
I wrote below formula, but it did not worked. NOTE: The TIN numbers are 9 digit
IF REGEX_Match([Recipient's U.S. TIN], ".*(?:(\d)\1{8})") THEN "Invalid" ELSE "Valid" ENDIF
Attaching the screenshot of the data for quick reference. Any help is highly appreciated
Regards,
Surya
Solved! Go to Solution.
Details
Test cases