Hi guys,
In the workbook that I have uploaded, you'll see that I have two columns (A,B) of raw data.
I want to remove duplicate data from column A to column D while keeping at the same time their related values from column B to column E.
I used an array formula in column D but I can't use the same formula in column E because it will not consider the relation between values from column A and B to column D and E.
What better formula can I use in order to remove duplicates from column A while keeping their respective values from column B?
Bookmarks