Try this:
B1=IF(A1>1,A1,"")
drag it down column B (if that's what you r using) or to suit.
Corey....

"g" <g@discussions.microsoft.com> wrote in message
news:021334A2-488A-4347-8C36-4E3B0F6C575B@microsoft.com...
> Hi, I am trying to get excell to auto fill a list of names onto a
> spreadsheet, the only twist is that if the name is blank it need to move
> onto
> the next available cell, what is the formula for this???
>
> Thanks
>
> G