I have a long list with codes in sheet 1 of my data starting at A2 (the list is very long 4500 rows):
<tbody>
C56
A125
R89
C56
B125
B125
A125
R89
D512
S226
D512
R89
</tbody>
In sheet 2 I need to create a list of all the codes and remove the duplicates. I'm using the...