Hi Stuart

You could try this in D2 and drag down
HTML Code: 
until it gets to 0 then #N/A which means no more data in column A.