I have a series of columns, say A, B, C, D, E, F. Each of the cells in these
columns have drop down menus with "0" or "1" as the possible responses. For
each individual row is it possible to have only one answer of "1" and
autofill the other 5 columns with "0"? For example if "1" is selected in row
5 column A, row 5 columns B,C,D,E,F return "0" or if "1" is selected in row 6
Column C, row 6 columns A,B,D,E,F return "0" etc.

Hope this makes sense.

Cheers!