Good Afternoon,
Thanks Zbor for your help and effort,actually Column "A" is the shortes list after A. filtering
and column "B" is the longest the reason they have duplicate string.when i get my correct result all 3 columns should be the same as column "A" with 165 rows.
If you look at my expected result columns "H"and "I" they dont have any duplicate so far
with the helper columns "J :M" if you try to insert any row with red colour string, it would change to a green colour that mean its duplicate so you change it and choose different one with "0".I hope explained clearly.
Thanks for your time
sem