B8-B31 = time of day, military, P8-P31 = number of cars passing through the intersection

[trafficcount]

how do we extract the highest number (max) of the cars passing through the intersection AND at the hour of which it occurs?


thanks~!

[Tony Valko]

For the highest number (max) of the cars passing through the intersection:

=MAX(P8:P31)

For the hour at which it occurs:

=INDEX(B8:B31,MATCH(MAX(P8:P31),P8:P31,0))

[trafficcount]

Thanks for the awesome and so quick reply Biff,
is there a way to combine the two functions into the same cell?
=max
=index
?

[trafficcount]

oh no need BIFF, i just had to change the cell to show TIME, THANKS AGAIN!!

[Tony Valko]

You're welcome. Thanks for the feedback!