I have in column H random sequences of rows with numbers , each sequence of
rows is seperated by an empty row. in column M I have a formula
=RANK(H1,H1:H11) copied down , in column N i have a formula :
=IF(M1<=15,CHOOSE(M1,100,75,56,42,34,24,18,13,10,8 ,6,4,3,2,1)) copied down .
each new sequence has to start and stop between the empty rows .

H M N needs to be M N
100 1 100 1 100
100 1 100 1 100
100 1 100 1 100
98 4 42 2 75
92 5 34 3 56
92 5 34 3 56
90 7 18 4 42
87 8 13 5 34
81 9 10 6 24
79 10 8 7 18
66 11 6 8 13
empty row empty row
100 1 100 1 100
98 2 75 2 75
77 3 56 3 56
63 4 42 4 42
0
0
empty rows empty rows

If the numbers in column H are duplicates the rank order is the same , but
M4 needs to be the 2nd rank order , not the 4th rank order and so on . also
when there are zerow's in rows of column H there should be blank cells in
the corresponding cells in columns M and N as above

Can this be done?
Thanks in advance

regards bill gras

















--
bill gras