I’m Reading 2 excels 8am.xlsx & 8pm.xlsx with the same column names. I need to compare the column"URN"(Col index 6) from 8pm.xlsx in 8am.xlsx. if matches keep the row , if do not match delete the entire row in 8am.xlsx.
Please Suggest me the solution. Thank you.