Need formula to check if cells below are <

[bill_s1416]

I have a spreadsheet and in column g are values that are "supposed" to be in ascending order (I can't re-sort the data and I don't want to bore anybody with the explanation.) I need to put a formula in column h that checks if the corresponding cell in g is greater than "any" of the cells below it.

 

[KenWright]

In H1 assuming your numbers start in G1, in cell H1 put

=COUNTIF($G2:$G$27,"<"&G1)>0

and copy down.

Might also want to take a look at the RANK function.

 

[Brian from Maui]

I have a spreadsheet and in column g are values that are "supposed" to be in ascending order (I can't re-sort the data and I don't want to bore anybody with the explanation.) I need to put a formula in column h that checks if the corresponding cell in g is greater than "any" of the cells below it.

=$G$1>G2 and drag down

or

=COUNTIF(G2:G100,"<"&G1)

 

[Seti]

Something like this?

Assuming you have 100 rows from row 2 to 101 and are putting this formula in H2 to check to see that G2 < G3....G101

=IF(G2>MIN(G3:$G$101),"Out of Order","")

Then copy down from H2 to H101.