Roger,
A better alternative !
(but there's beauty, too <g in the earlier volatile one)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message
...
Hi Max
Utilising your row count, the OP could alternatively use the non volatile
=INDEX(Sheet1!D:D,INT((ROWS($1:1)-1)/5)+2)
--
Regards
Roger Govier