If

[anon125]

i have two colums of increasing numbers.
the first time column b is greater than column a i want to put an arro
in the next column.
So far whatever i do it puts the arrow every time the b is greater tha
col a.
any ideas?
thanks
Ji

 

[Richard Buttrey]

i have two colums of increasing numbers.
the first time column b is greater than column a i want to put an arrow
in the next column.
So far whatever i do it puts the arrow every time the b is greater than
col a.
any ideas?
thanks
Jim

One solution starting in C2

=IF(AND(B2>A2,B1<=A2),"arrow","")

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________