SOLVED
Home

How to delete specific email ids from MS Excel 2007.

%3CLINGO-SUB%20id%3D%22lingo-sub-212741%22%20slang%3D%22en-US%22%3EHow%20to%20delete%20specific%20email%20ids%20from%20MS%20Excel%202007.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212741%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%201%20list%20of%20unsubscribe%20email%20ids%20and%20lots%20of%20lists%20of%20subscribers.%20I%20want%20to%20remove%20emails%20contained%20in%20Unsubscribed%20list%20from%20all%20of%20my%20Subscribed%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20formula%2Foption%2Fsorting%2Ffilter%20through%20which%20i%20can%20directly%20remove%20emails%20contained%20sheet%20A%20from%20emails%20list%20of%20Sheet%201%2C%20Sheet%202%20and%20further%20from%20all%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20paste%20Unsubscribed%20email%20ids%20in%20column%20B%20of%20all%20of%20my%20subscribed%20sheets%20and%20want%20to%20remove%20those%26nbsp%3B%20emails%20from%20Column%20A%20if%20any%20contains.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-212741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMS%20excel%202007%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-224264%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20specific%20email%20ids%20from%20MS%20Excel%202007.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-224264%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Matt%2C%20it%20worked%20very%20well.%20Thank%20you%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-217411%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20specific%20email%20ids%20from%20MS%20Excel%202007.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217411%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20please%20provide%20some%20kind%20of%20non-sensitive%20sample%20mockup%20file%20for%20the%20community%20to%20test%20their%20solutions%20on%3F%26nbsp%3B%20The%20formula%20I%20provided%20should%20contain%20a%20text%20string%20in%20Column%20C%20(not%20an%20email)%20indicating%20whether%20you%20need%20to%20delete%20the%20value%20in%20Column%20A.%26nbsp%3B%20Then%20you%20can%20just%20filter%20on%20Column%20C%20and%20delete%20the%20emails%20in%20the%20filter%2C%20leaving%20only%20the%20emails%20that%20you%20do%20not%20wish%20to%20delete.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-217287%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20specific%20email%20ids%20from%20MS%20Excel%202007.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217287%22%20slang%3D%22en-US%22%3E%3CP%3EI%26nbsp%3B%20am%20unable%20to%20get%20results.%20It%20showed%20some%20emails%20in%20Column%20A%20but%20those%20are%20not%20from%20Column%20B.%20Kindly%20explain%20more%20on%20the%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-212833%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20specific%20email%20ids%20from%20MS%20Excel%202007.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212833%22%20slang%3D%22en-US%22%3E%3CP%3EMaybe%20try%20something%20like%20this%20based%20on%20the%20description%20you've%20given%20(See%20attached%20.xlsx%20file%20for%20reference)%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20797px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37177iB4546160A4BC20AA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22DeleteMe.png%22%20title%3D%22DeleteMe.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-212822%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20specific%20email%20ids%20from%20MS%20Excel%202007.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212822%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20helper%20column%20to%20each%20of%20your%20sheets%20starting%20from%20second%20one%2C%20like%3C%2FP%3E%0A%3CPRE%3E%3D(COUNTIF(Sheet1!A%3AA%2CA1)%26gt%3B0)%3C%2FPRE%3E%0A%3CP%3Eif%20in%20column%20A%20your%20ID%3As%20(emails)%2C%20filter%20that%20column%20on%20TRUE%20and%20remove%20these%20rows.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
CS Pooja Arora
New Contributor

I have 1 list of unsubscribe email ids and lots of lists of subscribers. I want to remove emails contained in Unsubscribed list from all of my Subscribed list.

 

Is there any formula/option/sorting/filter through which i can directly remove emails contained sheet A from emails list of Sheet 1, Sheet 2 and further from all sheets.

 

or

 

If i paste Unsubscribed email ids in column B of all of my subscribed sheets and want to remove those  emails from Column A if any contains.

 

 

5 Replies

Hi,

 

You may add helper column to each of your sheets starting from second one, like

=(COUNTIF(Sheet1!A:A,A1)>0)

if in column A your ID:s (emails), filter that column on TRUE and remove these rows.

 

Solution

Maybe try something like this based on the description you've given (See attached .xlsx file for reference):

 

DeleteMe.png

I  am unable to get results. It showed some emails in Column A but those are not from Column B. Kindly explain more on the issue.

Can you please provide some kind of non-sensitive sample mockup file for the community to test their solutions on?  The formula I provided should contain a text string in Column C (not an email) indicating whether you need to delete the value in Column A.  Then you can just filter on Column C and delete the emails in the filter, leaving only the emails that you do not wish to delete.

Hi Matt, it worked very well. Thank you :)

Related Conversations
Teams - Chat History
David Gorman in Microsoft Teams on
8 Replies
Remove MS shifts schedule from a Channel in MS Teams
John Crook in Microsoft Teams on
17 Replies
Move Channels between Teams
HerculesConsen in Microsoft Teams on
11 Replies
Auto-Add new employees
Mathias Koprek in Microsoft Teams on
14 Replies
Getting Started - Creating a team accross two tenants
bw-ipim in Microsoft Teams on
40 Replies