View Single Post
  #6   Report Post  
Max
 
Posts: n/a
Default

Put in E77:

=INDEX($C$77:$C$2000,MATCH(SMALL($C$77:$C$2000,ROW S($A$1:A1)),$C$77:$C$2000,
0))


Sorry, a correction to the formula above:

Put in E77:
=INDEX($C$77:$C$2000,MATCH(SMALL($D$77:$D$2000,ROW S($A$1:A1)),$D$77:$D$2000,
0))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----