Hello everyone!

I have got a excel file that looks the one below:

https://i.imgur.com/erW3inj.png

Now I need a loop that check each cell in Column "H", if there is two cells in column "H" that matches each other (in this case Cell 1 and Cell 6).
Check in Column "i" if there is any data in any of these cells, remove the cell that have no data in Column "i".See result result below:

https://i.imgur.com/MnaTwLe.png

Could someone help me with this?

Thank you in advance