| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging two columns and keeping the data from both | Excel Worksheet Functions | |||
| How do I make the A,B,C... on top of the columns hidden? | Excel Discussion (Misc queries) | |||
| How do I make a column in Excel into two columns for only A3-A8 | Excel Discussion (Misc queries) | |||
| When sorting info in columns, can I make it insert blank line bet. | Excel Worksheet Functions | |||
| How do you make an Excel workbook exclusive? | Excel Discussion (Misc queries) | |||
Linear Mode
