Confirming if multiple rows of numbers run in sequence

Hello,

Please see attached.

I'd like Excel to run a check to see if a row of numbers runs in sequence.

*As in row 4, the numbers dont have to incriment each time
*As in row 2, there may be gaps in the data
*As in row 6, the data cant increase and then decrease. Each subsequent number must be the same or high than the previous
*There could be varying amounts of numbers per row, hence the results being in column R

As an added bonus it'd be nice to see where an error occurs, but just knowing theres an error (column R) is the primary goal.

Thanks

Well this worked in all cases in your sheet

=NOT(COUNTA(A1:Q1)-1-SUMPRODUCT(--(B1:Q1-A1:P1>0))-SUMPRODUCT(--(B1:Q1=A1:P1)*(B1:Q1<>"")))

Forget that over thinking!

Simple conditional fomat

=(COUNTIF($A1:A1,">"&B1))

placed in cells a2:q6 will work!

Just higlight b1:q6

select conditional formatting from the ribbon

Select New rule

use formula to determine which cells to format

Paste my conditional formatting formula into the format values box

=(COUNTIF($A1:A1,">"&B1))

Click on the format button and choose your highlight!

click ok!

It works by counting values to the left of the current cell which are greater than the current cells value, it will ignore text and blank cells so should work in all cases!

make sure you only highlight column B:N, its not designed for column A!

I highlighted and entered and it worked fine!