I am using Excel 2003 on Windows XP.
I have a spreadsheet which has a number of columns (each representing a piece of equipment), which I am using to track downtime for the equipment.
When a piece of equipment goes down, the user is to enter an "X" in that column. Previously users could select more than one piece of equipment. For various reasons, I now want to restrict the user so that they can only put an "X" in for one piece of equipment per row.
Is there any way to do this?
Bookmarks