+ Reply to Thread
Results 1 to 7 of 7

Find unique occurrence of names across a number of columns

  1. #1
    Registered User
    Join Date
    09-04-2013
    Location
    Southport, England
    MS-Off Ver
    Excel 2011(for mac)
    Posts
    28

    Find unique occurrence of names across a number of columns

    I have 5 columns each representing a meeting with a list of up to 300 attendee names in each column
    I would like to use a macro to list in column 6 the names of those who have attended only 1 of the 5 meetings

    Thank you for your help

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Find unique occurrence of names across a number of columns

    Can you upload an example workbook showing your layout of data structure and your expected output?
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Find unique occurrence of names across a number of columns

    Hi,

    The following code will interrogate the cells in the range A1:E11 and generate a list in column H of values that only occur once in that range.

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  4. #4
    Registered User
    Join Date
    09-04-2013
    Location
    Southport, England
    MS-Off Ver
    Excel 2011(for mac)
    Posts
    28

    Re: Find unique occurrence of names across a number of columns

    Thanks for that. Can I ask a couple of questions. Why the countIf (Range("H:H") and can the list in column H start at row 1 instead of row 2?

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Find unique occurrence of names across a number of columns

    Error posting. Apologies
    Last edited by Logit; 12-20-2016 at 06:28 PM.

  6. #6
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Find unique occurrence of names across a number of columns

    The CountIf(H:H is there to check that the current cell isn't in the unique list already.

    To corrct the row that the unique list occupies, replace this:
    Please Login or Register  to view this content.
    with this:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-04-2013
    Location
    Southport, England
    MS-Off Ver
    Excel 2011(for mac)
    Posts
    28

    Re: Find unique occurrence of names across a number of columns

    that's great thank you. I'm happy with this so will close

+ 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] Find 1st Occurrence of Number and Return Value In nth Column
    By esiegal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-27-2015, 11:06 AM
  2. vba find unique names in multiple columns
    By Konexcelmath in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2014, 09:10 PM
  3. [SOLVED] Find the last occurrence of a value in multiple columns or a matrix
    By jbh001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2014, 02:07 AM
  4. [SOLVED] Find Duplicates and Add Number of Occurrence
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 12:15 PM
  5. Replies: 8
    Last Post: 02-06-2011, 05:00 PM
  6. Replies: 3
    Last Post: 10-27-2010, 08:05 PM
  7. Find unique number in columns and return column title
    By mkvassh in forum Excel General
    Replies: 3
    Last Post: 10-21-2010, 10:29 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