Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding data in a list that meets a specific criteria | Excel Worksheet Functions | |||
prevent data entry into cell? | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |