| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allowing Only Certain Entrees
I am using the spreadsheet as a tracking mechanism, how do I format a cell so
it will only take a certain entry. For example, the formula is set to only count s1 or s2 or s4. If someone hits s5 one data entry, I want the cell to reject it. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing a leading zero if there is one | Excel Discussion (Misc queries) | |||
| Allowing for a range using COUNTIF | Excel Worksheet Functions | |||
| Allowing only one entry in a range | New Users to Excel | |||
| Allowing Macros in Excel | Setting up and Configuration of Excel | |||
| Only Allowing Certain Codes In Column | Excel Discussion (Misc queries) | |||
Threaded Mode
