Hi I have a series of data points set out in two rows the first row is a date the second row is the values. I want to pull some summary stats about the series together e.g. max, min, average etc. standard stuff.
But I also want to return the date when the max value occurred, again standard index match stuff if there is only one max value, but looking at the data it could well be that I have more than one cell in the series that is at the max value.
I can't for the life of me work out how I would do this - but in instances where there is more than one item at the max value then I would like to match to that value and then return all the dates associated with that max value all concatenated in one cell.
Data looks something like this:
So in this instance the formula would return
Apr 21, Jul 21
This is something I would be a repeated task with new data dropped into the series each time I wanted to pull the summary stats together. Any pointers in how to achieve this wold be gratefully recieved!
But I also want to return the date when the max value occurred, again standard index match stuff if there is only one max value, but looking at the data it could well be that I have more than one cell in the series that is at the max value.
I can't for the life of me work out how I would do this - but in instances where there is more than one item at the max value then I would like to match to that value and then return all the dates associated with that max value all concatenated in one cell.
Data looks something like this:
Jan 21 | Feb 21 | Mar 21 | Apr 21 | May 21 | Jun 21 | Jul 21 |
10 | 10 | 14 | 16 | 14 | 8 | 16 |
So in this instance the formula would return
Apr 21, Jul 21
This is something I would be a repeated task with new data dropped into the series each time I wanted to pull the summary stats together. Any pointers in how to achieve this wold be gratefully recieved!