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!

How about an alternative.

Put a formula in column G:

=if(sum(a1:F1)=0,"","Error: Only one choice can be 1!")

Then format it with a nice bold red font.

Zoltan wrote:

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!

--

Dave Peterson

ps. You may want to consider using Optionbuttons (from the Forms toolbar) and
grouping them nicely. Then the problem of selecting more than one will go away.

If you want to try, visit Debra Dalgleish's site:
http://contextures.com/xlForm01.html



Zoltan wrote:

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!

--

Dave Peterson