If

A

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
 
R

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
Click to expand...

One solution starting in C2

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

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top