Leicestershire, Northamptonshire and Sussex secured their spots in the Vitality Blast quarter-finals with victories on a dramatic day with the group stage drawing to a close.
It saw the trio join Surrey, Kent, Gloucestershire, Nottinghamshire and Lancashire in the last eight – with Birmingham just missing out.
The Bears lost by three wickets at home to Northamptonshire and missed out on qualification for the knockout phase, which also meant stalwart Ian Bell will not be able to bat one last time for the county.
Bell, a five-time Ashes winner, announced his retirement earlier this month but was set to bat on for Birmingham if they made it through to the quarters.
He will not get that chance despite Adam Hose's 64-ball innings of 119 as Northamptonshire chased down 192 with seven balls remaining.
Bears looked set to progress when the visitors at Edgbaston were reduced to 71 for six, but Tom Taylor hit 50 not out in rapid time and Graeme White struck 37 off 12 balls to send the Steelbacks through.
They will play away to Central Group rivals Gloucestershire, who – led by Ian Cockbain's 89 – clinched a home quarter-final on October 1 with a narrow success over Somerset.
Babar Azam scored 42 and visiting captain Lewis Gregory 50 responded for the visitors but it was only enough for the away side to post 161 for seven.
Somerset needed a win to reach the last eight, but suffered heartbreak when Tom Smith hit four off the final ball to earn his side a two-wicket triumph.
In the battle for the wooden spoon, Glamorgan secured victory by six wickets over Worcestershire despite Hamish Rutherford's century.
Half-centuries for openers David Lloyd and Nick Selman ensured the Welsh outfit chased down 191 with two balls to spare.
Three wickets for Leicestershire captain Colin Ackermann helped the Foxes claim victory by 22 runs against Lancashire to book their place in the last eight as one of the best third-placed teams.
George Garton claimed four wickets but some big-hitting from Essex all-rounder Paul Walter on his way to 76 saw the hosts make 136 for nine at Chelmsford.
With Sussex knowing only a win would take them into the quarters, they were indebted to Garton and Calum MacLeod who rescued them from 59 for five with scores of 34 not out and 40 to set up a home clash against Lancashire.
Jason Roy stole the show in the battle of the England internationals between Kent and Surrey at the Kia Oval with 72.
Spitfires captain Sam Billings hit 50 and Joe Denly 29 as the visitors made 159 for eight following some supreme bowling by Liam Plunkett, who finished with three for 19.
In reply, Roy ended a string of low scores with a half-century and Laurie Evans top scored with 73 to help Surrey secure a seventh straight victory and top the South Group.
The sides will meet again at the same venue on October 1 for a place in the semi-finals.
Shaheen Shah Afridi recorded sensational figures of six for 19 to help Hampshire finish with a 20-run triumph over Middlesex.
Earlier in the day at the Ageas Bowl, Nathan Sowter and Thilian Walallawita picked up three wickets apiece to restrict the hosts to 141 for nine.
Middlesex looked on course to get home when John Simpson was at the crease, but when Pakistan bowler Afridi dismissed him for 48, it sparked the beginning of a crazy spell.
Hampshire's overseas player went on to pick up three more wickets from his next three balls to claim a hat-trick and six-wicket haul to help dismiss the away side for 121.
