Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i have 2 columns one column can be a number between 1 and 200,
depending on the number inserted there has to be a number between 1 and 20 outputted on the left column 1 column 2 1 1-10 2 11-20 3 21-30 4 31-40 5 41-50 and so on if a number between 1 and 10 is inputted a 1 should appear to the right |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I was wondering how to have excel have a specific number input | Excel Discussion (Misc queries) | |||
inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
find an exact number in a different sheet and use the cell containing the number to output information | Excel Programming | |||
making a cell fixed number to a input number | Excel Programming |