Hi,
Is there any way in which excel can recognise two numbers as a range? I
would like to create a kind of histogram which can describe how many times a
point along this range has been crossed over a specific time frame...

For example:

High Low
Day1 300 290
Day2 310 295
Day3 305 290
Day4 300 285

Range Day1 Day2 Day3 Day4 Count
280 0
285 x 1
290 x x x 3
295 x x x x 4
300 x x x x 4
305 x x 2
310 x 1
315 0