Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

data entry criteria

1 view
Skip to first unread message

cwignall

unread,
Jul 28, 2006, 6:55:30 AM7/28/06
to

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?action=getinfo&userid=36880
View this thread: http://www.excelforum.com/showthread.php?threadid=565949

FunkySquid

unread,
Jul 28, 2006, 7:35:26 AM7/28/06
to
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

@consumerdotorg Bernie Deitrick

unread,
Jul 28, 2006, 9:18:41 AM7/28/06
to
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" <cwignall.2bnjm1...@excelforum-nospam.com> wrote in message
news:cwignall.2bnjm1...@excelforum-nospam.com...

0 new messages