Forum Discussion

alexis bissonnette's avatar
alexis bissonnette
Copper Contributor
Aug 12, 2018

Formula to highlight error in a sequence

Hi, I am looking for a formula to find and highlight an error in a sequence that have characters and numbers: For exemple: A0005551 A0005552 A0005553 A0005564 (error in the sequence) A0005555 ...
excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Aug 12, 2018

Alexis,

 

based on your sample.

=IF(SUBSTITUTE(A2,"A",)-SUBSTITUTE(A1,"A",)=1,"","ERROR")

 

  • alexis bissonnette's avatar
    alexis bissonnette
    Copper Contributor
    Aug 15, 2018

    Thanks a lot, it works well!

Resources