data entry criteria
 

hi

i have a spreadsheet that has columns to indicate the outcome of
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 you
enter it in another it will flag it up or not let you?

can anyone help?


--
cwignall
------------------------------------------------------------------------
cwignall's Profile: http://www.excelforum.com/member.php...o&userid=36880
View this thread: http://www.excelforum.com/showthread...hreadid=565949

data entry criteria
 

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

cwignall wrote:
hi

i have a spreadsheet that has columns to indicate the outcome of
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 you
enter it in another it will flag it up or not let you?

can anyone help?


--
cwignall
------------------------------------------------------------------------
cwignall's Profile: http://www.excelforum.com/member.php...o&userid=36880
View this thread: http://www.excelforum.com/showthread...hreadid=565949

data entry criteria
 

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


"cwignall" wrote in message
...

hi

i have a spreadsheet that has columns to indicate the outcome of
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 you
enter it in another it will flag it up or not let you?

can anyone help?


--
cwignall
------------------------------------------------------------------------
cwignall's Profile: http://www.excelforum.com/member.php...o&userid=36880
View this thread: http://www.excelforum.com/showthread...hreadid=565949