View Single Post
  #8   Report Post  
Ola
 
Posts: n/a
Default

He

B1: =MAX($A$1:$A$20)
B2: =MAX(IF($A$1:$A$20<B1,$A$1:$A$20,""))
copy down

Ola Sandstrom

95
85
75
65
55
35
20
15
0
0