Dec 03 2018 10:21 AM
I have a column that is full of about 75 different names. I need to replace those names with their work ID numbers. Is there a way that this can be done without doing a replace function for each of the 75 names?
Dec 03 2018 10:28 AM
My first thought is to create a new blank column and use vlookup to find the ID numbers for each person -- and then to copy the values in the new column and paste over the names as values only. I do something similar to this frequently when I need to present data that contains student names.
Mar 12 2022 12:23 PM
Did you get solution for this, I am trying to anoymise data which is e.g a name with an ID, each name knows their ID number that is assigned to them, did you get a solution in the end
best regards
evonne