Filling Blank Cells in Row based on other Cells in Range - help!

bneater 

You needed to allow for a blank (space) in your Data Validation choices. Then a simple IF formula fills the x's all the way across, but leaves it blank and allows the other allowed entries if that's what's called for.

By the way, although your "list" for Data Validation is short enough to fit in the space allotted in the dialog box entirely, are you aware that you could also create a list elsewhere in your workbook, let's say in a sheet called DataVal, cells A1:A8 (or whatever), and then in the field in the dialog box just enter the address of that list. You can also give the A1:A8 range of cells a name ("AttendCodes" perhaps) and then just refer to the name =AttendCodes

Doing that gives you more flexibility in maintaining the list. Just be sure that one of them contains a space.