Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make range of cells mutually exclusive
Hi everyone,
I have a workbook in Excel 2003 that has 20 sheets. The workbook acts as a questionnaire. Each sheet has 6 columns of statements from which the user has to choose which one most applies. The statements are marked from 1 to 6. It does this by using data validation in the row below the statement. So if there is a statement in A3 worth 6 points then the data validation in A4 allows the user to choose either blank or 6. Down to F3 where F4 allows them to choose either blank or 1. Then the score for that statement is calculated by summing A4:F4. I know it's quite a messy way of doing it but something was needed quickly and this worked but the job snowballed and there are now up to 16 rows of statements on each sheet. Obviously if more than 1 cell in row 4 has a value then the score won't be right. I was wondering if there was some way to either make the cells in the range mutually exclusive or to maybe flash up a message to say that more than one cell has been given a value. Oh please help me someone! -- Deirdre (totally confused and bemused) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to make 6 columns mutually exclusive? | Excel Worksheet Functions | |||
2 IF Statements not mutually exclusive | Excel Discussion (Misc queries) | |||
Making checkboxes mutually exclusive | Excel Discussion (Misc queries) | |||
Help: Multiple filters with mutually exclusive items | Excel Discussion (Misc queries) | |||
Req: How to create multiple mutually exclusive filters | Excel Worksheet Functions |