| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hlookup
how do I lookup a value that is the minimum value from a range of cells?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hlookup
=MIN(range)
Ivan "mtitanium" wrote in message ... how do I lookup a value that is the minimum value from a range of cells? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hlookup
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:J20,A2:J2)) HTH John "mtitanium" wrote in message ... how do I lookup a value that is the minimum value from a range of cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hlookup? | Excel Discussion (Misc queries) | |||
| help with hlookup | Excel Discussion (Misc queries) | |||
| V+HLookup? | Excel Discussion (Misc queries) | |||
| Hlookup for row 3 and 4 | Excel Worksheet Functions | |||
| hlookup | Excel Discussion (Misc queries) | |||
Hybrid Mode
