| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find Min of a row, but only greater than zero?
Hi and sorry for the cross-posting but I'm desperate,
Does anyone know how to find the minimum of a row of numbers, but only for numbers greater than zero? I have over three hundred rows I need to perform this same function on, so naming the row is out of the question. For example, if my row is: 0 0 0 1 2 3 5 0 0.5 I want to find "0.5". TIA -- Matthew -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find within Workbook. | Excel Discussion (Misc queries) | |||
| if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| Using COUNTIF to find numbers within a range greater than the mean | Excel Worksheet Functions | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Threaded Mode
