| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Locate a Cell based upon criteria
I'm trying to locate a cell based upon certain criteria. For example:
=CELL("row",min(C6:C11)). What doesn't seem to work is using the Min function. Any thoughts on the best way to return a cell location? Many thanks for any help you can provide! |
|
#2
|
|||
|
|||
|
Try...
=CELL("row",INDEX(C6:C11,MATCH(MIN(C6:C11),C6:C11, 0))) Hope this helps! In article , "Stan" wrote: I'm trying to locate a cell based upon certain criteria. For example: =CELL("row",min(C6:C11)). What doesn't seem to work is using the Min function. Any thoughts on the best way to return a cell location? Many thanks for any help you can provide! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
| I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
