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

**trafficcount** · 06-10-2013, 06:42 PM

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** · 06-10-2013, 06:49 PM

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** · 06-10-2013, 06:58 PM

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** · 06-10-2013, 07:05 PM

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

**Tony Valko** · 06-10-2013, 07:13 PM

You're welcome. Thanks for the feedback!

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions