Remove Duplicates

firstly, thank you for your patience, as i am obviously dense.

i've deleted the 'deduped' sheet - and just have 'raw data' sheet.

I copied the latest 'complete macro' and ran, but nothing happened. duplicates still remain. could you please tell me what i'm doing wrong (again)? thanks.

1- Step one - remove duplicates
2- Countif

cheers