Using SCAN to find running max and min

[DRSteele]

Can someone please help me?

I'm trying to use SCAN to ascertain the 52-week highs and lows for stock prices.

Like these:

close	52-week high?
$ 44.36
$ 44.04	FALSE
$ 44.36	TRUE
$ 44.53	TRUE
$ 44.22	FALSE
$ 44.45	FALSE
$ 47.10	TRUE
$ 47.11	TRUE
$ 46.88	FALSE
$ 46.45	FALSE
$ 47.49	TRUE
$ 46.48	FALSE
$ 47.00	FALSE
$ 46.75	FALSE
$ 46.42	FALSE
$ 46.34	FALSE
$ 47.18	FALSE
$ 48.36	TRUE
$ 47.86	FALSE
$ 48.79	TRUE
$ 48.94	TRUE

 

[hagia_sofia]

Hello, how about:

=MAP(A2:A22,LAMBDA(x,MAX(A2:x)))=A2:A22

 

[DRSteele]

Hello, how about:

=MAP(A2:A22,LAMBDA(x,MAX(A2:x)))=A2:A22

Right! That works.

Designing these LAMBDA things hurts my head.

Thank you very much.

 

[Dave Patton]

Does the following work?
=A2:A22>A1:A21

 

[Dave Patton]

Please ignore post #4