i have an assignment at work and i need to compare some cells from a certain excel with another cells from another excel. The cells are all from the same column.
For example IF cell D3 from excel1 is not present in any cell in column D in excel 2 THEN new row and insert excel.D3 in column D.
The problem is that the excel1 is scraped from an email and the excel2 it’s a file that i already have. I’ve managed so far to extract and put the data from the email but i don’t know how to compare the two things.
That’s the scraped table
That’s the file where i need to search the cell