Hi Bernie
there is a problem with the formulas you gave me , the problem came about
with the zerro's . Can you change the formulas to exclude the zerro's ?

the problem as follows:

A B C

80 0 80
78
62
50
48
0
0
0

76 45 76
76
76
74
70
70
69
66
62
60
50

74 28 74
71
71
70
64
62
59
56
55
45

69 28 73
69
69
67
67
66
63
63
62
59
59
57
56
28

73 28 73
71
66
64
63
62
62
60
60
48
28

regards bill gras
--
bill gras


"Bernie Deitrick" wrote:

Bill,

Insert a blank row for row 1, then in B2, array enter the formula (enter using Ctrl-Shift-Enter)

=IF(A1="",MIN(OFFSET(A2,0,0,MIN(IF(A2:$A$500="",RO W(A2:$A$500),500))-1,1)),"")

In C2, array enter
=IF(A1="",MAX(OFFSET(A2,0,0,MIN(IF(A2:$A$500="",RO W(A2:$A$500),500))-1,1)),"")

Then copy down to match your data in column A.

Change the 500's to at least the number of rows that you actually have.

HTH,
Bernie
MS Excel MVP


"bill gras" wrote in message
...
Hi
I have in column " A" 500 rows with numbers in random sequences each
sequence has random number of rows , each sequence is seperated with a blank
cell (the result of a formula) some sequences have zerrows included.
I need to find the lowest number in each sequence and put that number in
column
" B" I also need to find the highest number and put that number in column "
C"
eg:- A B C
4 2 10
6
2
8
10
blank cell
7 7 50
9
11
13
50
18
21
30
15
blank cell
3 1 17
5
0
1
0
0
17
6

some sequences have two or more of the same numbers , in case of two ore
more of the same numbers only one is needed

can some one help me please

regards bill gras

--
bill gras