In analyzing a log file, I need to count the value in one column until the
value in another column is greater than or equal to a specified value. For
example count column AC that has the value of 36 until Column DD is = to 6.
Any ideas?

On May 12, 10:33*am, Tom wrote:
In analyzing a log file, I need to count the value in one column until the
value in another column is greater than or equal to a specified value. For
example count column AC that has the value of 36 until Column DD is = to 6.
Any ideas?

Tom,

What is your end objective? Do you need the cell at which the counted
value in AC is greater than the same counted value in DD? Do you need
to know if the counted value in AC actually reaches a point in which
it is greater than the same counted value in DD? Please provide more
detail. In general, you can use the COUNTIF function to get the count
of a certain value.

Best,

Matthew Herbert

Matthew,

I am using the following formulas to count column AC:
=INT(COUNTIF(R[-2]C[-1]:R[4196]C[-1],36)/60) - to get hours and
=MOD(COUNTIF(R[-2]C[-2]:R[4196]C[-2],36),60) - to get minutes

the formulas woud reside in specified cells

The end objective is to compute the amount of time in column AC with a value
of 36 occurring until column DD is = to 6 to determine when an alarm
occurred.

" wrote:

On May 12, 10:33 am, Tom wrote:
In analyzing a log file, I need to count the value in one column until the
value in another column is greater than or equal to a specified value. For
example count column AC that has the value of 36 until Column DD is = to 6.
Any ideas?

Tom,

What is your end objective? Do you need the cell at which the counted
value in AC is greater than the same counted value in DD? Do you need
to know if the counted value in AC actually reaches a point in which
it is greater than the same counted value in DD? Please provide more
detail. In general, you can use the COUNTIF function to get the count
of a certain value.

Best,

Matthew Herbert