Posted by Casey on May 24, 2001 9:39 AM
i have a worksheet that has approx 12000 rows, w/in those rows, there are part numbers in column A. some of those part numbers have duplicate part numbers w/in the 12000 rows in column A. what i'm trying to do is tell it to find the duplicate part numbers, label them false or whatever, just some value that i can tell it to sort by so i can delete it. so basically, what i want it to say is if a part number in A has a duplicate, then label it FALSE. i don't know code, only formulas, so if anyone can help me i would appreciate it!!