Yorkshire secured second spot in Group B with a seven-wicket win over Essex to book a home quarter-final at York on Friday.
Captain Dom Bess (3-32) and seamer Ben Coad (3-22) helped bowl out already-eliminated Essex for 151 inside 41 overs.
The Tykes then slipped to 15-2, but a second first-team half-century for England Under-19s man Will Bennison, who hit 60 off 59 balls, helped the visitors to their sixth win in eight group matches with more than 18 overs to spare – and a second quarter-final place in successive seasons.
Durham gained third place in the group but not before some late dramatic twists against the holders Worcestershire at New Road.
Worcestershire won the game by 77 runs on the back of being bowled out for a competitive 291, thanks largely to Tom Taylor’s quickfire 86.
Ben McKinney then plundered 82 from just 70 balls but when he was out with Durham on 141-6, they still needed a further 63 to be sure of finishing above the hosts in the group.
When three more wickets went down in eight balls for the addition of just five runs, at 199-9, Durham still needed five more to reach that initial target of 204. They got them but not long before being bowled out for 214.
Hampshire had their hopes of reaching the knockout stages for a fifth successive year ended by Derbyshire in a thriller at Southampton.
Martin Andersson made 125, his fourth hundred of the summer across all formats, enjoying century stands with Harry Came (62) and Brooke Guest (67) as Derbyshire totalled 317-5.
But former Hertfordshire player Andrew Neal then almost turned the game on its head in Hampshire’s reply.
Coming to the crease at 134-6, with 183 still required, he smashed 10 sixes in a 63-ball 110, his maiden professional century at the age of 26, before being caught on the boundary edge with nine runs still needed as Hants were bowled out for 309, with 10 overs to spare.
James Cracknell shared a third-wicket partnership of 202 with Nathan Fernandes (92) as Middlesex recovered from losing two early wickets to post a formidable 354-8 as they cruised to a 92-run win over Sussex at Radlett.
Half-centuries by former Middlesex man John Simpson (65) and Oli Carter (58) enabled Sussex to mount a respectable reply, but they were dismissed for 262 to finish bottom of Group B with just one win.