+ Reply to Thread
Results 1 to 4 of 4

Need Formula to Place Indicator After Comparing Two Columns

  1. #1
    Registered User
    Join Date
    06-01-2017
    Location
    Orange County, California
    MS-Off Ver
    Excel 2013
    Posts
    2

    Need Formula to Place Indicator After Comparing Two Columns

    Fam ID Has Doctor? Split Family?
    119501322 Yes
    142684606 Yes
    142684606 No
    142684606 Yes
    196721887 Yes
    548824945 No
    550817217 No
    238652523 No
    555132345 No

    I'm trying to figure out a formula that would return "Yes", or some other indicator, in the "Split Family?" column if rows with the same Family ID have different entries in the "Has Doctor" column. For instance, rows 2, 3, and 4 in the above example would return "Yes". I'm not sure where to start with this or if a formula is more appropriate vs code. Any help would be appreciated.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Need Formula to Place Indicator After Comparing Two Columns

    Maybe...

    Please Login or Register  to view this content.
    C2 copied down >> =IF(COUNTIF($A$2:$A$10,A2)<>COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2),"Yes","")
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    06-01-2017
    Location
    Orange County, California
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Need Formula to Place Indicator After Comparing Two Columns

    That seems to do what I need it to! Thank you!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Need Formula to Place Indicator After Comparing Two Columns

    You are very welcome. Happy to help.

+ 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. Formula Comparing Two Columns
    By RosieW in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2017, 04:36 PM
  2. Formula for Comparing Two Columns of Emails
    By Rack38 in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 09-26-2016, 05:09 AM
  3. Replies: 7
    Last Post: 10-07-2014, 10:15 AM
  4. [SOLVED] Need formula for comparing columns?
    By Miss Molko in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2014, 08:46 AM
  5. Macro to delete columns and place a formula
    By redzan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2014, 06:32 PM
  6. Comparing two columns for duplicates formula?
    By istharbgl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2013, 09:32 AM
  7. Text to columns where a formula is in place
    By Gooford in forum Excel General
    Replies: 4
    Last Post: 09-23-2009, 10:17 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