| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
"Aladin Akyurek" wrote: bj wrote: If you start out in row 3 (for example) change it to =large($P$4:$P$65536,row()-2) [...] What is going to happen if some rows are inserted before the formula row? The equation would have to be modified one way to do it would be to name a range equal to the first equation cell [initr = $C$3] change the equation to =large($P$4:$P$65536,row()-row(initr)+1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
| vlookup formulas returning no values | Excel Worksheet Functions | |||
| Returning all values from a lookup - not just the first/last one | Excel Worksheet Functions | |||
| Returning an answer in an if fuction between two values | Excel Worksheet Functions | |||
| Returning Multiple Values Based on One Value | Excel Worksheet Functions | |||
Hybrid Mode
