Can Anyone Help

[topdost]

I have a file in excel with 24K emails , and many other fields . I have managed to clean the list and have a new now with 20K email i.e 4K gone .

How do now filter the actual list as the new list just have the email and not the rest of files .

I need the new list i.e 20K to match the field that it has in actual list

 

[Endire]

Topdost,

You can use the Vlookup function in excel to highlight, sort and move data between sheets or between excel files. Here is a tutorial on how to do that,

http://office.microsoft.com/en-us/h...-records-in-large-worksheets-HA001056320.aspx

Best,

SHawn

 

[topdost]

thanks shaun

 

[jayrat14]

Topdost,

You can use the Vlookup function in excel to highlight, sort and move data between sheets or between excel files. Here is a tutorial on how to do that,

http://office.microsoft.com/en-us/help/use-hlookup-and-vlookup-functions-to-find-records-in-large-worksheets-HA001056320.aspx

Best,

SHawn

Vodooo... Thanks

 

[tompots]

Search and replace, I guess I don't know what the file looks like.