Thread: Is there a way to make 6 columns mutually exclusive?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default 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


Reply With QuoteReply With Quote