Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've got a column with a list of ordered values like this:
Code: 100000000 50000000 33333333 25000000 20000000 16666667 14285714 12500000 11111111 10000000 9090909 8333333 7692308 7142857 6666667 6250000 5882353 5555556 5263158 5000000 4761905 4545455 4347826 4166667 And a user enters a value, which could be anything up to the highest value in this column. I need a method of finding the lowest number in the column that is larger than the user entered value. for example, if the user entered 4500000, then the value I'd need would be 4545455. Any ideas on how I can accomplish this? **Note: you'll notice that this list of numbers has a pattern. It is 1/ N*100000000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find the lowest number in a given column | Excel Worksheet Functions | |||
Find Lowest Column Among Several | Excel Programming | |||
Find Lowest Column Among Several | Excel Programming | |||
Find Lowest Column Among Several | Excel Programming | |||
Find Lowest Column Among Several | Excel Programming |