Hi All,

I have a range of cells A1:A10. On cell B1, how can I create a formula that spit out an “error” message if there is more than one non-blank cell? In other words, I want to let the user enter a number or comment in one of the cells and leave the rest blank.

Thank you all,
VBisgreat