| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change value of cell automatically if entered the wrong number
I (sometimes) have a row with numbers from 1 to 5...
What I want is: when I enter value = 3, and that value (3) already exists in the column, it has to correct that automatically into 4, with or without a warning. Sometimes the row don't have values in it at all, if the value 2 is entered then, it automatically has to change to 1. In short: it has to change automatically in the first unused value closest to 0... Thanks for the help!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Track changes even if the number entered didn't change | Excel Discussion (Misc queries) | |||
| How do I get data automatically entered into a cell? | Excel Worksheet Functions | |||
| typed numbers entered in cell wrong | Excel Discussion (Misc queries) | |||
| How do I lock a cell automatically after it has data entered. | Excel Discussion (Misc queries) | |||
| How to get a cell to error if the wrong figue is entered | Excel Discussion (Misc queries) | |||
Threaded Mode
