Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplet with no previous values
I have a series of cells that I want to only accept predefined values from a list
I have set this up through the list option in validation which is working fine However, say if the list contained text values such as red, yellow and blue. How can I have the cell recognise these as r or y or b I know autocomplete does this but only is there is another entry in the column already. eg If there is no entry for red in the range then how can i force r to = red Bria |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TO Average Previous values | Excel Worksheet Functions | |||
Average of previous values | Excel Discussion (Misc queries) | |||
Delete row containing all previous values. | New Users to Excel | |||
Adding values from previous worksheets | Excel Worksheet Functions | |||
collecting previous values | Excel Programming |