Please refer to the attachment.
To extract the maximum value from column B that corresponds to a specific time, I?m using the cell formula
=MAX(IF(A$3:A$30000=726,B$3:B$30000))
(=MIN is substituted to find the minimum value).
The formula above is repeated approximately 700 times in cells/rows corresponding to each 1-minute increment (from 727, ie 7:27 am, to 1900).
I think a VBA solution would be more efficient. Perhaps someone could make a suggestion.
Thank you.
Grant.