How to find the largest value in a column?
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.
|