Thread: Code help?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fpd833 fpd833 is offline
external usenet poster
 
Posts: 23
Default Code help?

I have a data sample: 3000+ rows, and cols A:J. Col G is a phone number and
Col H is a qualifier. I'm looking for a macro that will look at col G,
identify all duplicate numbers then look at col H for duplicates within that
set. Example:

Col G Col H
Number Qualifier
123-456-7890 Apple
123-456-7890 Grape
123-456-7890 Apple

I want to cut and paste one of the "apple" rows into another sheet leaving 2
unique entries for that number. Is this possible?

Any help would be GREATLY appreciated. Thanks!