If Statment Ignoring NA's

[lmarkowi]

I have data that looks like the following:

I want to write a formula in the column to the right that identifies every instance in which the last value that came before it is less than the value in the cell. Example, I would want the formula to pick up when there is 10 that comes after the 9....Any suggestions?




Value
10
10
10
NA
NA
NA
9
9
9
NA
10
NA
9
8
7

 

[Oaktree]

B3 =AND(A3>LOOKUP(9.999999999999E+307,$A$1:A2),A3<>"NA"), copied down

Book18
	A	B	C	D
1	Value
2	10
3	10	FALSE
4	10	FALSE
5	NA	FALSE
6	NA	FALSE
7	NA	FALSE
8	9	FALSE
9	9	FALSE
10	9	FALSE
11	NA	FALSE
12	10	TRUE
13	NA	FALSE
14	9	FALSE
15	8	FALSE
16	7	FALSE
Sheet1

 

[Aladin Akyurek]

Care to be more specific about the outcome for it's hard to visualize what use a list of zero or more 10's can be put to?

 

[lmarkowi]

Here is the sheet,

[HTML removed by admin]

 

[Von Pookie]

See:
http://www.mrexcel.com/board2/viewtopic.php?t=239755