Hi, i have 2 excel.
I need to get “Person Number” from Excel 1 and check if the person number has a duplicate or existed in Excel 2.
if it has a duplicate Person number in excel 2 i need to filter the latest “Hire Date”
Output
Person Number | Hire Date
303030 | 9/17/2021
Thank you in advance.