Between two markers in one column, find the max/min value in another column and mark in a third column

[starlight89]

Hi,

I was hoping to get some help with something that is way beyond my Excel capabilities.

I have a set of data that is marked as "CT" in Column D. Between each pair of "CT" I need to:
1. Determine if the value next to "CT" in column C is 1 or -1
2. If the value is 1, I need to find the maximum value from column B between the two values of "CT" in column D. If the value is -1, I need to find the minimum value.
3. In the row that contains the max/min value, enter "ET/ST" in column E.

I need to be able to repeat this on any range between the two cells marked "CT".

Is there a way to do this without using VBA?

Thanks in advance!

[TABLE="width: 256"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]Time[/TD]
[TD]Price[/TD]
[TD]Side Est[/TD]
[TD]Cross Time Indicator[/TD]
[/TR]
[TR]
[TD]12:00:00[/TD]
[TD]99.5[/TD]
[TD]1[/TD]
[TD]CT[/TD]
[/TR]
[TR]
[TD]12:32:00[/TD]
[TD]100.5[/TD]
[TD]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12:39:00[/TD]
[TD]100[/TD]
[TD]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12:46:00[/TD]
[TD]100.5[/TD]
[TD]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12:53:00[/TD]
[TD]100[/TD]
[TD]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12:56:00[/TD]
[TD]99.5[/TD]
[TD]-1[/TD]
[TD]CT[/TD]
[/TR]
[TR]
[TD]13:06:00[/TD]
[TD]100[/TD]
[TD]-1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]14:47:00[/TD]
[TD]97.5[/TD]
[TD]-1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]14:50:00[/TD]
[TD]98[/TD]
[TD]-1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]14:53:00[/TD]
[TD]98.5[/TD]
[TD]1[/TD]
[TD]CT[/TD]
[/TR]
</tbody>[/TABLE]