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.
HansVogelaar this is the dataset. I want to take the month, in this example January, and calculate the 20% and 80% percentile. After this I want to calculate February and so on. But when I drag down my calculation under 20% and 80% it only goes down one row in the left table. Instead I want it to skip around 30 rows to the date beginning 01/02/1972. Are you able to help?
nq003524 "this is the dataset" ????