Creating New Formula

R

Raich

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.
 
R

ryguy7272

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----
 
Top