Though, would there be any solution for the problem you presented. If there are two persons with the same name one of the will be deleted. Can I avoid this...

Got it!

Thanks so much for all your help!

Thanks.

To be sure, wouldn't this work as well? (PARTITION BY namn ORDER BY Säsong) since namn (the name) doesn't change, but tröjnummer (which is the number on their sweaters) might...

I'm so sorry for that.

Here comes a screenshot, as you can see Aaron Downey is there several times, the code took away the dups when the value for the "Lag"...

Thanks!

Though it doesnt delete the duplicates with the codes that you all have been so kind to give me.

This (below) doesn't result in deleting all the dups. I only want...

Thanks old hand!

Though, the code didn't work for me. The result I got had several duplicates still I am afraid.

Another question: When I want to repeat the last command and...

Hmm, I can't make it work. Look, i might as well give you a sample of my sheet so you see all the correct column names and so forth (I...

Thanks for responding. The logic is the latest säsong (season) 2008-2009 in this case, meaning that I want the results for Aaron Downing 2008-2009 but not the others.

/F

Thanks for responding. The logic is the latest säsong (season) 2008-2009 in this case.

/F