Hi,
I have two columns and would like to find the the value from the second column which does not exist in the first one and add it to the first empty cell in the column 1. for example, in the table below, I want to add ID 55555 from column ID 2 to the forth row in column ID 1. I know how to find the first empty cell in column 1, I just dont know how to tell excel to set A5 to value in B4
ID 1 ID 2 First Empty Cell
12243 12243 A$5$
3254346 3254346
546574 55555
2022-08-05 21_55_35-data - Excel.png
Bookmarks