Dear all,
A strange thing, I have a list with material numbers and need to remove duplicates.
And wether I do it with this VBA code :
Or wether I do it with the remove duplicates option in the data tab of Excel 2010 it just leaves material 1000463HJ double.
Strange thing is when I shorten the list to a sample size including 1000463HJ is does remove the duplicate :/
The material is around line 400 and not the last in the range so I don't think the list is too long.
Also there are no spaces both cells give length of 9
I attached a sample workbook with the material list in column A and the smaller sample in column D.
As said if I remove duplicates on column A it does not work for 1000463HJ but for column D it does work.....
Any thoughts?
Thanks.
Bookmarks