| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Min Value using array ignores Zero
Im trying to search a two column list using the following formula. Its an array formula which I know not very much about.... {=MIN(IF((Sheet2!$F$3:$F$3500=E3)*(Sheet2!$J$3:$J$ 3500),(Sheet2!$J$3:$J$3500)))} Its working almost perfectly. The only problem Im having is if the values are, for example: 10 2 5 100 12 0 It will pick the 2 not the Zero. I need to be able to pick the Zero in cases such as this. Does anyone have hints on a tweak to the formula? Gavin -- mauddib ------------------------------------------------------------------------ mauddib's Profile: http://www.excelforum.com/member.php...fo&userid=4169 View this thread: http://www.excelforum.com/showthread...hreadid=346025 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Where is the bug in my array? | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
