Script / Macro Request - Match row A to Row B - Or other solution?
We have all 900 students in 4 houses.... each house has a security group and each students has been added to the group where needed.
BUT.. They have now decided that we now only need 3 houses and all students have been rehoused into 3 on the MIS system.
We now need to somehow link an exported list from our MIS system (with the new list of Names and Houses) to an exported list from AD.
Unfortunely the names on the MIS system do not always match the names in AD.. e.g. John.Bloggs vs Jonothan.Bloggs.
Does anyone please know how I can match up two lists in Excel to the best fit.
Maybe with a % score of how well they matched? so we could then manually check the lower % matches?
Otherwise we are going to have to go through 800 students adding them to security groups !
Thanks in advance
AD MIS HOUSE
08Jon.bloggs | Jonathon Bloggs | Sebright