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...
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" ????