| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum array formula.
Can anyone help me please.
I am trying to find the minimum figure (excluding zeros) from a column using an array formula. My formula is as follows: =MIN(IF(A10:A300=Title,IF(B10:B3000,C10:C300,0),0 )) The figures in column c are formulas driven from another tab, and the title is a drop down list to choose job titles. For some reason my formula always returns a minimum of zero when zero's are present. Hope this makes sense. Can anyone help, it's driving me insane????? Many thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula Minimum Excluding Text | Excel Discussion (Misc queries) | |||
| Minimum Formula | Excel Discussion (Misc queries) | |||
| How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
| Minimum Distance Calculation using Array and Geographical Coordinates | Excel Discussion (Misc queries) | |||
| Finding minimum value across selected rows of an array | Excel Worksheet Functions | |||
![Confused_Euffy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
