+ Reply to Thread
Results 1 to 3 of 3

Removing / Delete same contents from columns

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Kerala, India
    MS-Off Ver
    Excel 2013
    Posts
    87

    Thumbs up Removing / Delete same contents from columns

    Hi!

    I am using MS Office Professional Plus 2010

    In the file attached I have 'Column A' with Many Email addresses and 'Column B' with Some Email addresses (selected email addresses from Column A) which are to be removed from 'Column A'

    I wish to have 'Column C' with All Email addresses of 'Column A' except the ones in 'Column B'

    I have manually did it in the Test file.


    Thank you
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    786

    Re: Removing / Delete same contents from columns

    Power Query
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,050

    Re: Removing / Delete same contents from columns

    Please try at C1

    =IFERROR(INDEX($A$1:$A$20,AGGREGATE(15,6,ROW($A$1:$A$20)/ISNA(MATCH($A$1:$A$20,$B$1:$B$20,)),ROWS(C$1:C1))),"")
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Delete contents of a cell if another has any contents
    By new guy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-09-2020, 02:25 PM
  2. [SOLVED] removing parentheses and contents from end of string.
    By barrowinfurnace in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2018, 09:12 AM
  3. [SOLVED] Macro to delete contents of cells if user delete contents of other cells
    By Stuartzz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-24-2018, 08:28 AM
  4. Comparing contents in 2 columns of pivote tavle & if contents found same then generate
    By Parag Chincholikar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-21-2014, 05:40 AM
  5. Removing Certain Cell Contents
    By chris8800 in forum Excel General
    Replies: 4
    Last Post: 04-12-2012, 01:43 PM
  6. Replies: 5
    Last Post: 02-06-2011, 04:35 PM
  7. [SOLVED] Delete the contents of columns if the month changes
    By hamad.fatima@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2006, 11:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1