Identify consecutive number strings

[ollyhughes1982]

Hi all,

I was wondering if anyone knows of a way in Excel, to identify consecutive number strings in a column? What I want to do is have a ‘1’ in column FV whenever the 4-digit string in ‘FU’ is made up of 4 consecutive numbers. i.e. 0123, 1234, 2345 etc. When this is not the case I would like the cell to appear empty (“”). I have included a screenshot of my columns below:

The string in FU is always 4 digits, as it is made up of the minutes / seconds components of a time field.

Also posted on Excel Forum: Identify consecutive number strings

Thanks in advance!

Olly.

 

[Phuoc]

Try this:

=IF(MOD(FU4,1111)=123,1,"")

 

[ollyhughes1982]

Thanks. This has now been solved. Thanks for your help