Using an IF statement to sort data
Posted on 2015-02-03
I am attempting to identify the minimum value occurs before the maximum value, but would like to know if there is a function that I can use, rather than using a macro.
In detail, in row 4, I find the minimum value of 2 and the maximum value of 410. I would like to return the date (the header row) of the minimum value and the date of the maximum value IF the minimum value occurs before the maximum value. If the maximum value occurs before, then return nothing.
I have been racking my brain with an IF statement or a combination of IF and range, but am drawing a blank. I have a sparkline in place to help visualize how the values fluctuate.