I'm trying to write a macro that will loop down a column and find identical
numbers, then check the values in the offset cells 3 columns away, decide
which value should be kept, and then delete the rows containing the unneeded
values. In other words, if I have 4 rows with the following number in column
C:

8475727

And the value in column F for these four rows is a possibility of :

EARTH
AIR
FIRE
WATER
ICE
STEAM

I want the macro to keep the rown containing "EARTH" if it's available and
delete the other rows. However, if "EARTH" is NOT available, I want it to
pick "AIR" and delete the rest. If "AIR"'s not available, I want it to pick
"FIRE", and so on.

Any insight into how this could be accomplished would be sweet. I'm fairly
new at VBA Programming, and this one is beyond me.

Thanks!