| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I find the first value in a column less than a number?
What I have is a large number of cells (more than 7 so nested IF isn't an
option) that I need to find the first value that is less than a number. For example: 41 21 78 24 90 55 31 36 62 10 88 44 etc. And I want to display the first number under 20 (which is 10). How would I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| how do I find an average number of specific words in a column | New Users to Excel | |||
| Number of Column Limitations | Excel Discussion (Misc queries) | |||
| How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
Threaded Mode
