Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
row number within a formula
I am trying to use the row number within a formula.
For example, instead of =MIN(A2:A25) I would need to incorporate ROW(A25) into the formula. Something like this: =MIN(A2:A"ROW(A25)") although this syntax is incorrect. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
row number within a formula
On Mon, 15 Jan 2007 07:43:00 -0800, Charles
wrote: I am trying to use the row number within a formula. For example, instead of =MIN(A2:A25) I would need to incorporate ROW(A25) into the formula. Something like this: =MIN(A2:A"ROW(A25)") although this syntax is incorrect. Thanks! Here's one way: =MIN(OFFSET(A2,0,0,24)) --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
row number within a formula
This would be a two step process:
1. Somewhere in the worksheet (e.g. B1) enter ="A2:A" & Row(A25) 2. Where you want the result returned enter =MIN(INDIRECT(B1)) Regards Paul Charles wrote: I am trying to use the row number within a formula. For example, instead of =MIN(A2:A25) I would need to incorporate ROW(A25) into the formula. Something like this: =MIN(A2:A"ROW(A25)") although this syntax is incorrect. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
If formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |