[Solved] Excel keep 1st three rows and delete rest of duplicates [closed]
So, going the VBA route, you’ll need to loop through each row in your tab and test the value to see if it’s a duplicate, if it’s a duplicate then you’ll increase a counter variable and once that counter variable hits 3 you start deleting rows. This is a little complicated if you haven’t worked … Read more