Is there a way to make 6 columns mutually exclusive?
 

I am creating a spreadsheet for electronic input from vendors. There are 6
mutually exclusive columns for a row. I want an error to print if data is
entered in more than one column.
Thanks for any and all help. Sandie

Is there a way to make 6 columns mutually exclusive?
 

=IF(COUNTA(A1:F1)1,"Error","OK")
--
David Biddulph

"Sandie D" <Sandie wrote in message
...
I am creating a spreadsheet for electronic input from vendors. There are 6
mutually exclusive columns for a row. I want an error to print if data is
entered in more than one column.
Thanks for any and all help. Sandie