I need to compare two excel spreadsheets to see if the dead people got paid.
One spreadsheet is a list of people that died, the other spreadsheet is a list of people that got paid.
There are no unique identifiers on either spreadsheets, but there are combinations of columns that may prove to be unique. For example: the name, payment type, and amount columns appear on both spreadsheets.
My team suggested I concatenate the columns that are unique in both spreadsheets and make that one column my unique identifier. I believe this makes sense, but I wanted to know if there was a better solution.
If this is a good method, is there even a way to first prove that the combinations of these columns are unique?
