Forum Discussion
How to make your formula jump rows
I'm the percentile function to calculate 20 and 80 percentiles from a list of data registered to a date. I need to work it out month by month. However when I drag my formula down it only goes down on...
You can use the OFFSET or perhaps INDEX function for this.
Without knowing what the data look like it is impossible for me to provide more specific help.