Hi Chris

Can you sort the data first? You could add a temporary column with the row number in (as a value, not as a formula) so you can 'un-sort' it later. You can then delete the temporary column. The problem is that macros ignore the autofilter when counting rows. Sorting gets around this - you wouldn't need to use Autofilter.

Alternatively, go through the entire list keeping a record (in a temporary table or array?) of how many times you've seen each ID. When it reaches 10, start deleting rows with that ID in.

Cheers, Rob.