I created a macro that extracts soc. sec. # from a list of employees once I
write Last Name of Employee. I used Index & Match commands but my problem is
that employees may share the same last name, even same first name like father
and son. I even tried the VLookup command. How do I go about getting it
right.
Example, If last name is found more than once, then write first name and if
found more than once, write prefix like Jr. or Sr. to distinguish, else write
soc. sec. #.
Thanks in advance.