Matching best Bid and Ask per minute

Hi,

I would like to be able to match the best Bid and Ask per minute. In other words, i would like
the lowest Ask to be matched with highest Bid. I've got an intraday dataset
with ID indicating Ask and Bid (Ask=1, Bid=0), price, and timestamp down to second of the day.
I'm not sure how it could be practically extracted, or whether an direct calculation of Bid-ask spread
would be the best solution.

I've attached an example with the numbers i want matched in bold. Any help would be appreciated

Best
ExcelNick

Thank you, Glenn!

The formula seemed to be working at the first minutes I wanted to calculate, however it started
to skip some minutes (which had observations) and even further down the minutes I wanted to calculate it completely stopped.
I've tried for some while to figure out why, but can't seem to get any wiser. Is there some sort of limitation to the formula?

Also, is it possible to account for date as well as minute? I want the best bid and best offer for each minute from 04:30-18:00,
for about a year worth of days.

I appreciate the help and will continue trying to make the formula work

Best
ExcelNick

Sorry!

I managed to make the function work, but would still like to know how "date" can be implemented.
I've attached an example of desired result. Hope everything is clear

Best
ExcelNick

That worked perfectly!

Thank you very much, Glenn
Have a nice day

Best
ExcelNick96