Find occurance of value "x" after value "y"

**Corbijn** · 11-13-2012, 01:50 PM

I'm trying to set up a simple formula that tells me if I've input a value lower than the highest value input across the row:

A B C D E F G H I

Frequency 1 1 1 1 2 2 1 2

So in the example above, as soon as I enter "1" in column H, the formula would indicate "error".

Thanks in advance!

**Moo the Dog** · 11-13-2012, 02:01 PM

Well, you can't enter a formula in the cells where you are entering actual data. However, you can use conditional formatting to color the cell to show if an error exists.

So if your range of numbers was in A1:H1, select cells B1:H1 and apply Conditional Formatting using the following formula:

Formula:

Please Login or Register  to view this content.

and change the formatting to whatever you want as an error alert and click OK to apply.

- Moo

**Ace_XL** · 11-13-2012, 02:06 PM

In data validation in B1 use

Whole number --Greater than or equal to -- =A1

Copy and paste special --validation across

**e.isayev** · 11-13-2012, 02:18 PM

You can enter this array formula to know if there greater value or not.
=IF(SUM((OFFSET(A1,0,COUNTA(1:1)-1,1,1)<OFFSET(A1,0,0,1,COUNTA(1:1)))*1)>=1,"Greater Value","Its Ok")

**Marcol** · 11-13-2012, 02:26 PM

Does this workbook help?

I'm assuming you are manually entering the numbers.

It's not bullet proof but it will Return "ERROR" when the next number entered in a row is less than the previous max of that row.
At least one cell in columns C:L of the row must have a number to trigger the formula.