I am working to have a validation on a SharePoint list. One of the requirements is in column A, it should does not contain serial number what are the numbers that in one way only +1 differ from each other.
For example in column A:
In this example, the number in the top 4 rows only differs +1 and should return an error on validation.
I have found a way to separately extract the character number. But you still need help on how to compare the different rows to detect the different +1 and return the error.
I hope to have a help to form the community. Thanks in advance.