Outputting Discrete data from continuous dataset

[ahume12]

Hi there

I am having some issues putting a formula together to extract data from a continuous data set into a discrete data set.

I have existing table data which shows temperature between two locations in miles. In this dataset, the temperature is recorded at a non uniform/continuous interval
So the data could show 23.7 degrees between 59.01 and 59.19 miles and 21.0 between 59.19 miles and 59.37 miles.

I would like to process this data into a standard dataset, which outputs the minimum temperature between two uniform mileages
So the output data would be 59.00 to 59.25 is 21 degrees, which is the minimum temperature of the above within the bound of 59.00 to 59.25.

I have tried excel "ifs" function as well as some "if" "and" combined functions, but cant get anything that approaches the correct solution.

Would appreciate any help

Thanks
A

 

[Peter_SSs]

No problem.

BTW, if you don't mind #NUM! instead of #N/A you could use this slightly shorter version.

ahume12.xlsm
	A	B	C
1	Miles From	Miles To	Min Temp
2	59	59.25	#NUM!
3	59.25	59.5	#NUM!
4	59.5	59.75	25.2
5	59.75	60	25.2
6	60	60.25	25.2
7	60.25	60.5	17.3
8	60.5	60.75	17.3
9	60.75	61	21.4
10	61	61.25	16.9
Data To

Cell Formulas
Range	Formula
C2:C10	C2	=AGGREGATE(15,6,VLOOKUP(Table2[@[Miles From]:[Miles To]],Table1,3),1)