Regex Workflow

[Suryachoppakatla]

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

[Suryachoppakatla]

changes

[Suryachoppakatla]

Details

[Suryachoppakatla]

Test cases