how do I lookup a value that is the minimum value from a range of cells?
J John Jul 28, 2008 #3 You can try: =MIN(A2:J2) (MIN ignores empty cells, but those "empty" cells may actually contain masked zero values) If so, you could try this, array-entered, ie press CTRL+SHIFT+ENTER to confirm the formula: =MIN(IF(A2:J2>0,A2:J2)) HTH John
You can try: =MIN(A2:J2) (MIN ignores empty cells, but those "empty" cells may actually contain masked zero values) If so, you could try this, array-entered, ie press CTRL+SHIFT+ENTER to confirm the formula: =MIN(IF(A2:J2>0,A2:J2)) HTH John
