I have 4 columns of data and 96 total rows to find the largest value in
column D based on the largest value of colum C. Here is what the information
looks like:

Col. A Col. B Col. C Col. D
1/1/05 00:00:00 1500.35 465.50
1/1/05 00:15:00 2331.52 396.45
1/1/05 00:30:00 2630.18 751.66
1/1/05 00:45:00 475.00 0.0
1/1/05 01:00:00 2630.18 756.75

In this case, I would like the number 756.75 to be displayed.

I would like any help I can get.

You could probably use the following formula:

=MAX(IF(C1:C96=MAX(C1:C96),D1:D96,"")) entered with CTRL+SHIFT+ENTER,
since it's an array formula.

Scott

needofhelp wrote:
I have 4 columns of data and 96 total rows to find the largest value in
column D based on the largest value of colum C. Here is what the information
looks like:

Col. A Col. B Col. C Col. D
1/1/05 00:00:00 1500.35 465.50
1/1/05 00:15:00 2331.52 396.45
1/1/05 00:30:00 2630.18 751.66
1/1/05 00:45:00 475.00 0.0
1/1/05 01:00:00 2630.18 756.75

In this case, I would like the number 756.75 to be displayed.

I would like any help I can get.

=MAX(INDEX((MAX(C2:C6)=C2:C6)*D2:D6,0))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"needofhelp" wrote in message
...
I have 4 columns of data and 96 total rows to find the largest value in
column D based on the largest value of colum C. Here is what the
information
looks like:

Col. A Col. B Col. C Col. D
1/1/05 00:00:00 1500.35 465.50
1/1/05 00:15:00 2331.52 396.45
1/1/05 00:30:00 2630.18 751.66
1/1/05 00:45:00 475.00 0.0
1/1/05 01:00:00 2630.18 756.75

In this case, I would like the number 756.75 to be displayed.

I would like any help I can get.