+ Reply to Thread
Results 1 to 2 of 2

Need assistance creating formula to locate matching cells from 2 different spreadsheets

  1. #1
    Registered User
    Join Date
    06-22-2014
    Location
    canada
    MS-Off Ver
    2010
    Posts
    12

    Need assistance creating formula to locate matching cells from 2 different spreadsheets

    hoping I can trouble someone for assistance. I have 2 spreadsheets containing email addresses. need a way to identify which addresses from Sheet B match the ones in Sheet A - and ideally delete them. or highlight them in a way that will be easy to identify and delete manually . sample attached. the real version has about 3000 rows of emails in the master sheet - and 200 in the sheet of addresses which I need to remove. not all of them will necessarily be in the master sheet. thanks for your time and help !
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Need assistance creating formula to locate matching cells from 2 different spreadsheet

    May be using VBA, you can do this automation.
    Can I suggest you something else?
    Try this formula in column B (in cell B2) of Sheet 1:
    =IF(ISNA(MATCH(A2,Sheet2!$A$1:$A$2,0)),"","Delete")

    Then filter the column by "Delete" and remove the rows.

+ 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] Formula to Locate Matching Data in Workbooks and return a value to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2016, 10:19 PM
  2. [SOLVED] Formula to Locate Matching Data in Worksheets and return Yes or No
    By hammer2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-04-2016, 07:48 PM
  3. [SOLVED] Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2015, 01:20 AM
  4. [SOLVED] Formula to Locate Matching Data in Worksheets and return a value to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2015, 08:42 AM
  5. [SOLVED] Formula to Locate Matching Data in Worksheets and return Yes or No to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-24-2015, 06:51 AM
  6. [SOLVED] Formula to Locate Matching Data in Worksheets and return a value to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-10-2015, 04:55 AM
  7. [SOLVED] Formula to Locate Matching Data in Worksheets and return a value to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2014, 11:38 PM

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