| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I pick a number from a list in Excel?
I have a list of 99 different numbers. In one cell a person can type in a
number, and after they do that I want it to pick the smallest number that is larger than the one they listed. For example: The list is 1,2,3,4,5 They enter 3 I want it to pick 4 since that is the smallest number that is larger than the one they entered. Thanks for any assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
