+ Reply to Thread
Results 1 to 2 of 2

Finding if two different cells match down in a column

  1. #1
    Registered User
    Join Date
    02-27-2018
    Location
    Lincoln Ne
    MS-Off Ver
    13
    Posts
    1

    Finding if two different cells match down in a column

    Is there a way to find out (not using concatenate) if a truck and its associated date exist further down in the columns?

    For example: Truck 73 has a date of 01/01/2018 (and is duplicated at the bottom). What formula can I use to determine if that is duplicated down further in the columns?


    Need a formula for Col C.
    Col A Col B Col C
    Truck date Duplicated?
    73 1/1/2018 Yes
    34 2/13/2013 No
    90 2/24/2013 No
    83 2/25/2013 No
    40 1/16/2013 No
    73 1/1/2018 Yes

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Finding if two different cells match down in a column

    Try this
    Enter in C2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    OR this
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B C
    1
    2 73 1/1/2018 Yes
    3 34 2/13/2013 No
    4 90 2/24/2013 No
    5 83 2/25/2013 No
    6 40 1/16/2013 No
    7 73 1/1/2018 Yes
    Last edited by AlKey; 02-27-2018 at 01:56 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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] Finding the last column using MATCH
    By L.LEE in forum Excel General
    Replies: 5
    Last Post: 01-08-2017, 01:25 PM
  2. [SOLVED] Finding intersection value of specific row and column that match a certain value
    By Nikox9 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2016, 02:48 AM
  3. Excel 2013, finding match in cell from range (column)
    By Rob de QUartel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2014, 05:58 AM
  4. [SOLVED] Finding a partial match within a column
    By kestefon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2013, 02:14 PM
  5. [SOLVED] Finding a match in part of a column
    By j_Southern in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2013, 07:42 AM
  6. Replies: 4
    Last Post: 02-19-2013, 02:19 PM
  7. Match Limitations: not finding value in cells with alot of text.
    By vipjun in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-10-2007, 05:58 AM

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