Results 1 to 14 of 14

Formula Help for isolating two columns based on NO MATCH

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2023
    Location
    Canada
    MS-Off Ver
    Microsoft Office 365
    Posts
    30

    Formula Help for isolating two columns based on NO MATCH

    Hi there,

    I have uploaded my test excel.

    I am looking to pull table data from column's B & C into a separate table only if the adjacent value in column A reads FALSE.

    The end goal is to have a two-column table that returns the values in column B & C where the where there is NO MATCH in columns B & D. The common values to search would be in columns B & D, but I don't know how to filter out the matches and only show the non matches while ensuring the data in column B & C are tied together when being returned.

    As one can see, I have created column A with the formula ISNUMBER(MATCH(B2,$D:$D,0)) that looks for whether a match is exists in columns B & D with TRUE meaning there is and FALSE meaning there isn't. I could just filter from all "FALSE " data in column A whenever I want to see that data, but I would rather it have its own tab (EG. "NO HISTORY") where it automatically populates the values in column B that have no matches (along with adjacent column C).

    Any help would be appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need a formula to pull site info from based on a match in the next columns
    By PlebBrain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2022, 06:41 AM
  2. [SOLVED] Formula for isolating data within a cell and copying it over to the adjacent column
    By the_red_engine in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2021, 01:58 AM
  3. Using index match based on two match criteria in different columns
    By LearningByError in forum Excel General
    Replies: 2
    Last Post: 08-02-2018, 01:57 PM
  4. Replies: 4
    Last Post: 04-14-2017, 07:47 PM
  5. Isolating Duplicates - Multiple Columns
    By tjm1987 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-19-2013, 10:31 AM
  6. Replies: 6
    Last Post: 09-11-2013, 03:24 AM
  7. Replies: 6
    Last Post: 12-10-2012, 06:26 PM

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