RRatajczyk
New Member
- Joined
- May 16, 2018
- Messages
- 22
Please Help!
I am looking for a formula that will identify/detect when a part number is identical (a match) in a long list of part numbers and where it is different in the sequence by one character or number. i.e. ABC123456 vs ABC123465
the result would be "True" where this occurs
In other words the part numbers are identical with the exception of one of the characters or numbers is out of sequence (= TRUE)
and the whole long list of part numbers is being evaluated / compared
I am looking for a formula that will identify/detect when a part number is identical (a match) in a long list of part numbers and where it is different in the sequence by one character or number. i.e. ABC123456 vs ABC123465
the result would be "True" where this occurs
In other words the part numbers are identical with the exception of one of the characters or numbers is out of sequence (= TRUE)
and the whole long list of part numbers is being evaluated / compared
Last edited by a moderator: