Having trouble finding the right function
Try this:
B1=IF(A11,A1,"")
drag it down column B (if that's what you r using) or to suit.
Corey....
"g" wrote in message
...
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
|