roscoe
Well-known Member
- Joined
- Jun 4, 2002
- Messages
- 1,046
- Office Version
- 365
- Platform
- Windows
- MacOS
I have a column of data with gaps every third row (for plotting a line with gaps). I need to create a dynamic range for the column of data. I can mess with a formula using "count" and then add 50% but I thought I could be more clever and take advantage of the fact that the bottom value is always the maximum value.
Any idea how to do this?
Thanks!
Any idea how to do this?
Thanks!