+ Reply to Thread
Results 1 to 6 of 6

VB Code to find Unique names and consolidate

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to find Unique names and consolidate

    Hello:

    Please refer to attached file.
    I have data as shown.
    I need VB Code to get the unique names from Cell G3 down and paste at M3.
    Now I need consolidated data for each employee in column N3 down.
    I have shown 2 manually entered data in cell M3:N4

    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files

  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: VB Code to find Unique names and consolidate

    This can be easily done with two formulas:
    Tot get unique names
    Enter in M3 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    then in N2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    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

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to find Unique names and consolidate

    Hello Alkey:

    I really wanted to have VB Code to add to existing code.
    I appreciate your great help always for great formula's you have been providing me, very smart.
    Thanks
    Riz

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to find Unique names and consolidate

    Hi Alkey:

    I think i will use your formula approach.
    Thanks a bunch.
    Riz

  5. #5
    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: VB Code to find Unique names and consolidate

    Then use one to SUM
    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.
    Last edited by AlKey; 11-19-2016 at 05:44 PM.

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: VB Code to find Unique names and consolidate

    Hi Riz

    VBA Solution...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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] VB Code to find unique names
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-16-2016, 05:37 PM
  2. Code to find Unique Names
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2016, 04:29 PM
  3. VB Code to find Unique Names
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-30-2015, 06:42 PM
  4. 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
  5. Find unique names in certain range.
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 07-22-2014, 04:00 PM
  6. [SOLVED] Find duplicates in multiple worksheets and consolidate based on unique id
    By desibabuji in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-14-2013, 04:09 PM
  7. [SOLVED] Find unique names and count their status
    By webstmonkey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2013, 01: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