VLOOKUP and LEN/ISNA to match names?
My THOUGHT was to build on BOTH sheets a column that contained values
you could then match - but I can see that if the data is formatted in
such a way that you CANNOT do it you are going to have problems -
possibly counting the instance of the surname and matching off the
unique values, then working through the rest would be a possible
solution - especially if this is a one off or occassional event!
|