Use Excel To Calculate Several ranges within one column
 

I need to know if this is possible without creating a circular reference.

I have two columns Eace in which some conditions are possible Column P and
Column Q, in each of these the value can be a 0 (No event Occuring) 1 (Event
Occuring) M (event End Type One) T (Event End type 2)

I also have two Count Colums to count the duration of Each since at the end,
if there are two events present, Only the event with the longer duration will
be evaluated These Colums are columns T & U.

To Get the count for the evaluated event, I check for an endevent value in
Columns AT or AS which is numerical
=IF(OR(AT58<"",AS58<""),MAX(T58:U58),"") The Preceding value is in column
AV.

Now On to what I need, I need to be able to determine the range of each
event evaluated. I have gotten this far the following will provide me with
the cell reference for the beginning date of the range
=IF(AU58<"",CONCATENATE("CD",(ROW()+(AQ58-1))),"")

That happens when I try to use this calculated reference in a cell, is that
I get a circular reference (one of the calculations I need to do is divide
then end value of the calculation by an average on the beginning date) The
other thing I need to do is aget a Min and a Max For each of the values in
the ranges of dates that these events occur in.

Any Ideas?

Best Regards,

Tim Henning