data entry criteria

C

cwignall

hi

i have a spreadsheet that has columns to indicate the outcome o
certain accounts at work.

for example:

Not proceeding
Gone Elsewhere
Changed Mind
Going Ahead

etc.

i need to make it so that you can only enter 'y' in of of them...if yo
enter it in another it will flag it up or not let you?

can anyone help
 
F

FunkySquid

It may be easier to say '1' for yes and '0' for no. That way you can
have a simple formula:
=IF(SUM(A2:D2)<>1, "Error", "OK")
where columns A-D are your 4 columns

FunkySquid
 
B

Bernie Deitrick

Select your cells, then use data / data validation... custom, with a formula like

=COUNTIF($C5:$F5,"y")=1

Where $C5:$F5 are the cells that should only have 1 y in them.

You can select multiple rows and use the same formula, just use the address of the first row of the
selection in the formula.


HTH,
Bernie
MS Excel MVP
 
Top