Hello everyone!
I have got a excel file that looks the one below:
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:
Could someone help me with this?
Thank you in advance
I have got a excel file that looks the one below:
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:
Could someone help me with this?
Thank you in advance
Last edited: