Results 1 to 2 of 2

Thread: Check if a name is present in several columns

  1. #1

    Check if a name is present in several columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi I want a way to check that a persons name is not listed in more than one column. So I have several columns with names. A persons name must be in 2 columns. How can I set up a formula or formatting to check several columns and tell me who has only got their name entered once?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,499
    Articles
    0
    Excel Version
    Excel 2016
    You can select the range.... Assuming A2: D100, then go to Home|Conditional Formatting, New Rule.

    Select "use a formula to determine which cells to format"

    Then enter formula:

    =COUNTIF($A$2:$D$100,A2)=1

    Click format and choose from Fill tab.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •