So many entries

  • Thread starter Thread starter swmasson
  • Start date Start date
S

swmasson

hi there,

I have 3000+ entries in 1 column, many are duplicates - ie. LPG01 in A1
and A2 the same and in A3 the same.... I think you get the idea.

What i need to do is filter just one entry for each different code, i
think theres 290 codes so to do the auto filter could take all night.

Thank you for your help.

Kind regards

Steve Masson
 
HI again,

I actually used access to tackle this problem, by copying all th
columns entries and pasting them into access not allowing duplicates
access was able to remove all the duplicates.

EASY!

Thank
 
Back
Top