Compare data from one column/spreasheet to another?
Are you intentionally trying to expose yourself to litigation by storing SSNs
in a non-secure environment like Excel?
--
Brevity is the soul of wit.
"Carrie" wrote:
I have a spreadsheet from a vendor with SSNs only and I need to find the
employee names.
I have a spreadsheet of my own employee data, contaiing SSN, name, hire and
term date.
I need to match the SSN from the first list to the names on the other.
Do I need to keep the info in separate spreasheets or can I combine the data
into 1 spreasheet and still have it find matches? Either way, how can I find
out which name goes with the list of SSNs the vendor provided me?
|