Nottinghamshire's last-ball win earned them top spot in Group B and a home quarter-final in the Royal London Cup.
Kane Williamson converted his maiden century for Yorkshire into a fine 189 to put the home side on top against Sussex.
Alex Hales and James Taylor scored centuries as Notts kept their Royal London One-Day Cup quarter-final hopes alive.
Sussex defeated Somerset in the only one of six Royal London One-Day Cup fixtures to beat the bad weather on Sunday.
Phil Mustard scored a fine half-century as Durham condemned Glamorgan to a third straight Royal London Cup defeat.
Peter Trego hit a second straight Royal London One-Day Cup hundred to help Somerset to a six-wicket win over Middlesex.
England fast bowler Steven Finn is “back to his best”, according to Middlesex assistant coach Richard Johnson
Middlesex have confirmed England fast bowler Steven Finn has signed a new three-year contract with the county.
Steven Finn has been recalled to the England squad for the fourth Investec Test against India.
Kent scraped a two-run Duckworth-Lewis victory in a thrilling Royal London One-Day Cup clash with Somerset at Taunton.
Somerset enjoyed a winning start to their campaign in Group B of the Royal London Cup, while Glamorgan saw off Surrey.
Yorkshire saw off rivals Lancashire by 47 runs in their Royal London One Day Cup opener, despite a ton from Karl Brown.
Glamorgan secured the last quarter-final spot in the South Group, while Sussex's Luke Wright made a record 153 not out.
A record T20 crowd at Lord’s were treated to a thrilling finish as Surrey beat Middlesex on the last ball of the game.
The inaugural Royal London One-Day Cup, county cricket's new 50-over competition, gets under way on Saturday.
Yorkshire reclaimed the County Championship lead with a 220-run victory over Middlesex at Scarborough.
Andrew Gale scored 126 not out as Yorkshire batted all day to move into a commanding lead over Middlesex.
Ryan Sidebottom took seven wickets for Yorkshire but John Simpson's knock of 110 helped Middlesex fight back on day two.
Yorkshire opener Adam Lyth became the first batsman in Division One to complete
1,000 Championship runs this season.
Glamorgan have signed their former seamer James Harris on a month’s loan from Middlesex.