Forum Discussion

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

Silver Contributor

Aug 12, 2018

Alexis,

based on your sample.

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

alexis bissonnette

Copper Contributor

Aug 15, 2018

Thanks a lot, it works well!