Forum Home
Press F1
Thread ID: 86665	2008-01-24 10:22:00	Excel formula	bpt2 (6653)	Press F1

Post ID	Timestamp	Content	User
633555	2008-02-03 19:31:00	Hi I wrote that myself. I'm not familiar with the list object but it sounds like an array - which is what I used. You could sort the list and compare each item to the next item. What I did was to loop though the list twice (with one loop nested inside another) - start at 1 and compare it to everything else in the list. If it finds a match then exit the sub indicating a duplicate was found. If it doesn't fine one on the first pass then select the 2nd item and repeat the process, and so on. Andrew	andrew93 (249)
1 2