Delete rows based on column data

[Atthebeginning]

I have a worksheet with 38,000 rows and 16 columns. I'm trying to write something where when the number (excluding blanks and the number 0.00) in column G matches Column H that it will recognize it and then delete both rows. Any help would be greatly appreciated? As a side note the duplicates it's search for is comparing column G and H. Therefore if for example a number is in column G once and column H fifty times, it will only delete the two rows. Meaning that the ending result would be the number is no longer in column G and appears in column H 49 times since is only appeared once in column G. I hope this helps.

[jaslake]

Hi Atthebeggining

Welcome to the Forum!!!

Please include an example of this in your File attachment...

for example a number is in column G once and column H fifty times, it will only delete the two rows. Meaning that the ending result would be the number is no longer in column G and appears in column H 49 times since is only appeared once in column G