Can Anyone Help

topdost

Regular Member

Oct 10, 2011

364

51

• Mar 8, 2013

• #1

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

Elite Member

Mar 27, 2012

1,756

1,075

• Mar 8, 2013

• #2

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

Regular Member

Oct 10, 2011

364

51

• Mar 8, 2013
• Thread Starter Thread Starter

• #3

thanks shaun

 

jayrat14

BANNED

Feb 6, 2011

1,110

137

• Mar 8, 2013

• #4

TheContentAuthority said:

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

Click to expand...

Vodooo... Thanks

 

tompots

Elite Member

Dec 11, 2011

5,775

4,871

• Mar 8, 2013

• #5

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