| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
minimum value in range
Min = Application.WorksheetFunction.Min(Range(Cells(Row% , 6), Cells(Row%,
9))) if min=0 then....... This command ignores blank cells , but i also want it to ignore cells containing a value 0, or 0.0 or 0.00 , is this possible |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get a row number of range where a value is between minimum and max | Excel Worksheet Functions | |||
| Sum of minimum values in a Range. | Excel Discussion (Misc queries) | |||
| The second minimum value in a range | Excel Worksheet Functions | |||
| How do I get "minimum value" in a range to NOT return zero? | Excel Worksheet Functions | |||
| Minimum value in a range > 0 | Excel Discussion (Misc queries) | |||
Threaded Mode
