I have a list of individual mobile numbers and a second list of the same
numbers but with each number duplicated several times. On the list with the
duplicate numbers I have their tariff info. I need to search for the
individual numbers on the duplicate numbers list and add the tariff info to
the individual number list!?!?!?!?! Please help.

You may be able to simplify this. Select the column with the dupes. Click
Data Filter Advanced Filter Unique Records Only and Copy to Another
Location. Does that give you what you want?


Regards,
Ryan----


--
RyGuy


"Raich" wrote:

I have a list of individual mobile numbers and a second list of the same
numbers but with each number duplicated several times. On the list with the
duplicate numbers I have their tariff info. I need to search for the
individual numbers on the duplicate numbers list and add the tariff info to
the individual number list!?!?!?!?! Please help.