"Vba Dictionary with key and sub key (not doubel)"

[daboho]

i have data in col A (item) and i want unique keys in col B:I in same row
and paste result in col k what wrong with my code bellow thankyou

Please Login or Register  to view this content.

[Bernie Deitrick]

Here is how you would do what you want with a dictionary object:

Please Login or Register  to view this content.

But - you could also use Excel's built in "Remove Duplicates" function:

Please Login or Register  to view this content.

[daboho]

very very thankyou sir but i was wrong in data key1 also unique ,now i was add doubel data in no 1,2,3,4,1,4,etc
but i your coding also for key not unique thankyou