JPHADFIELD
New Member
- Joined
- Jul 8, 2013
- Messages
- 1
I'm using a match function as part of a formula to pull back data from an array. The first column in the array contains dates and the second the data points I want to analyse.
I need to analyse the data for various date ranges, but the data is externally sourced and therefore some dates (such as weekends) may be missing. I thought I could use the match type to find the lowest or highest near value where the actual date was missing, (type '1' for the start of the the range, type '-1' for the end), but the match types require the data to be sorted differently.
This is part of a much larger model, so I had hoped not to have to re-write the whole thing. Does anyone know a way around this?
I need to analyse the data for various date ranges, but the data is externally sourced and therefore some dates (such as weekends) may be missing. I thought I could use the match type to find the lowest or highest near value where the actual date was missing, (type '1' for the start of the the range, type '-1' for the end), but the match types require the data to be sorted differently.
This is part of a much larger model, so I had hoped not to have to re-write the whole thing. Does anyone know a way around this?
