Forum Discussion

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

...

Thank you for your help

2 Replies

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!

Resources