Forum Discussion
Re: How to make your formula jump rows
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.
2 Replies
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" ????
