Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |