How, in a column of numbers, all relative minimum can be identified?

**manmehdiam** · 12-13-2011, 10:40 PM

How, in a column of numbers, all relative minimum can be identified?
Suppose,
The first column shows the date and the next column is the stock price.

What can be a relative maximum(or minimum) price determined For each stock price?
For example,For the calculation of a stock1 in column B the following numbers 10 and 12 relative to the minimum and so the numbers 80 and 50 and 90 as a maximum is relative.(below)

Heartily thank you for spending valuable time.

date(clmn. A) stock1(B) stock2(C) stock3(D)
2011/12/10 $80
2011/12/11 $60
2011/12/12 $10
2011/12/13 $20
2011/12/14 $30
2011/12/15 $50
2011/12/16 $40
2011/12/17 $32
2011/12/18 $12
2011/12/19 $42
2011/12/20 $90
many tanx for any help.

**dilipandey** · 12-13-2011, 11:16 PM

Hi manmehdiam,

For relative min, use following formula and drag it down till you need minimums.
=SMALL(B:B,ROW(B1))

For relative max, use following formula and drag it down till you need maximums.

=LARGE(B:B,ROW(B1))

See the attachment for better understanding.

Regards,
DILIPandey

<click on below 'star' if this helps >