ROW() is sensitive to the cell its placed in. If your data starts in other
than row1, you could replace ROW() with ROWS($1:1), viz:

In H180:
=IF(D180="","",ROWS($1:1))

In I180:
=IF(ROWS($1:1)COUNT(H$180:H$186),"",INDEX(D$180:D $186,SMALL(H$180:H$186,ROWS($1:1))))

Copy H180:I180 down to I186, and it'll work fine, returns in I180:I186
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"Sean" wrote in message
...
Thanks Max / Mike

On your formula Max, I've tried a simple test and it works, but when I
apply it to my actual data I get a <blank in a cell which I expect it
to return a string. I'll explain-

In D186 I have a formula =IF(AB$178="","","Sunday in - "&AB$178), this
produces a text string (I have <blank returns in D180:D185)

Based on your Formula for "B" I have entered in H186
=IF(D186="","",ROW()). this produces 186 as a result (I have <blank
returns in H180:H185)

Based on your formula for "C" I have entered in I180 =IF(ROW()COUNT(H
$180:H$186),"",INDEX(D$180:D$186,SMALL(H$180:H$186 ,ROW()))), this
produces a <blank in I180. I would have expected it to return the
text string that is displayed in D186.

has it anything to do with how I return my value in D186?