Deleting rows using complex(custom) filtering

Hi all,

I'm new to XL programming therefore we will be hopefully seeing each other more often.

At the moment I'm helping out molecular biologists with an excel sheet they need 'filtered" in a specific way, but i cant seem to get my head around it since I'm not that good

In the attached example i need to write a script which will filter out some specific occurences of genes and their positions. The VBA filter should in practice:

delete all the the ROWS of data WHERE:
= for a unique "Gene.name" ALL the "Position.build" numbers are the SAME

The rest must be untouched.

For example:
most of the rows contain "gene.name"s with alot of same "position.build"s but a few which are different or a group of "position.build"s that are different. In this case everithing should be kept as is and untouched.

Position.Build	Gene.name

7597374	      A2BP1
7597374	      A2BP1
7597374	      A2BP1
7699165	      A2BP1
7699165	      A2BP1
these we keep b-coz they have a variation of posion.builds(eaven though some are duplicates)

8887233          A2ML1
8895779          A2ML1
8896159          A2ML1
8901938          A2ML1
8905022          A2ML1
8907840          A2ML1
these we keep also - the pos.build is different within the gene

but these we delete b-coz they r ALL the same position.build within the same gene and there is no other different position within the gene:
52243704	A1CF
52243704	A1CF
52243704	A1CF
52246074	A1CF
52246074	A1CF
52246074	A1CF

Wooow what a challenge ah? at least for me it is untill i learn...

Like I said, i'm new to this all and would appretiate some pointers on how to use the code and if possible comments within code so that i could learn and then be more proficient and be able to help around the lab.