Formula challenge - flag out of sequence codes
We have a simple list of 4-digit alphanumeric codes like A001, A002, A003, etc. What formula can we use to mark codes that are "out of sequence" with previous entries? This problem includes two separate challenges.