+ Reply to Thread
Results 1 to 2 of 2

Compare a cell to the contents of two columns, output conflicts to a separate cell

  1. #1
    Registered User
    Join Date
    09-11-2019
    Location
    america
    MS-Off Ver
    2016
    Posts
    1

    Compare a cell to the contents of two columns, output conflicts to a separate cell

    So im trying to make an excel worksheet for events. I was wondering if there is a way for the cells in the error column can scan to see if the contents in a row for the date and time columns conflict with any others. Ill attach a doc to show what i mean, i apologize in advance if my explanation isn't very clear.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Compare a cell to the contents of two columns, output conflicts to a separate cell

    This formula in the conflict column & copied down will show conflicts if the date & start time are the same.
    Please Login or Register  to view this content.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

+ 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] Compare two columns of data and output contents of a third column when there is a match
    By BENTLEY1984 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-11-2018, 10:00 AM
  2. Compare values and output cell titles, able to output multiple results
    By TMG2016 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-07-2016, 11:42 AM
  3. Replies: 4
    Last Post: 06-10-2014, 12:21 AM
  4. [SOLVED] (Partial Contents of a Cell Output to Another Cell
    By Msimm14 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-31-2013, 06:14 PM
  5. Macro to compare 2 columns cell contents and add 'Yes' flag for record
    By swarren6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2013, 03:50 PM
  6. Replies: 1
    Last Post: 01-10-2013, 12:52 AM
  7. Excel 2007 : Split Cell Contents into Separate Columns
    By slkamath in forum Excel General
    Replies: 1
    Last Post: 01-01-2010, 12:52 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