| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the position of the lowest value in a row?
How do I find the position of the lowest value in a row in Excel?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find the position of the lowest value in a row?
=LOOKUP(2,1/(A1:A10<""),A1:A10)
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "melh31" wrote in message ... How do I find the position of the lowest value in a row in Excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find the position of the lowest value in a row?
This will give you the address of the cell in row number 2
=CELL("address",INDEX(2:2,MATCH(MIN(2:2),2:2,0))) Regards, Peo Sjoblom "melh31" wrote: How do I find the position of the lowest value in a row in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find within Workbook. | Excel Discussion (Misc queries) | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| Using the Find tool in EXCEL | Excel Worksheet Functions | |||
| Find lowest value in a range | Excel Worksheet Functions | |||
| How to find highest, lowest and last cell in a row? | Excel Worksheet Functions | |||
Hybrid Mode
