Ignore Blank cells and jump to next non blank cell

Originally Posted by yarlachiru

thank you rick
i am wondering, if this can be achieved with formulas only not macro

See bebo021999's posting in Message #8. Note that his formula assumes you have set up the header row and name column beforehand.