Working fine now. thank you all.

"Max" wrote:

Just replace ROW() with ROWS($1:1),
viz use in D2, copied down:
=IF(ROWS($1:1)COUNT(C:C),"",INDEX(A:A,SMALL(C:C,R OWS($1:1))))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Rob" wrote:
Thank you all for your answers they have all worked fine. One more questiuon
though using the formula that Max wrote, how can I change it to read row 2. I
have inserted a header in row 1 and therefore miss the first line of data
when i use the formula in D2 instead of D1