I got thousands of figures in Column A of the current worksheet. They are sorted and have the following make-up:
Is it possible by means of a formula or conditional formatting to show the ones where the sequence of '1' is not maintained,
Help is much appreciated. Thank you very much in advance.
I have attached a sample file for your convenience.