lukman4068
New Member
- Joined
- Jun 15, 2009
- Messages
- 24
Hi,
Here's my question -
I can't set my table as an excel table or "list" to allow for a dynamic range that way.
For this month, I can return the max value using the MAX formula as it is:
=MAX(F4:F16)
What i'd like to happen is for the F16 to change to F17 automatically when the new row is added. This could also be driven by a new month as the data is updated a monthly basis.
Hopefully you understand the question and what I'm trying to do.
I tried something like
=MAX(F4:&"F"&D1)
D1 is where I put the number of rows down I wanted the array to go from the start cell (F4)
I tried that to try and string it together :/ But it obviously doesn't work.
Appreciate the help in advance as ever!
Here's my question -
I can't set my table as an excel table or "list" to allow for a dynamic range that way.
For this month, I can return the max value using the MAX formula as it is:
=MAX(F4:F16)
What i'd like to happen is for the F16 to change to F17 automatically when the new row is added. This could also be driven by a new month as the data is updated a monthly basis.
Hopefully you understand the question and what I'm trying to do.
I tried something like
=MAX(F4:&"F"&D1)
D1 is where I put the number of rows down I wanted the array to go from the start cell (F4)
I tried that to try and string it together :/ But it obviously doesn't work.
Appreciate the help in advance as ever!