+ Reply to Thread
Results 1 to 4 of 4

macro to underline groups of data based on exact duplicates in column A

  1. #1
    Registered User
    Join Date
    03-19-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2011
    Posts
    37

    macro to underline groups of data based on exact duplicates in column A

    Hi,

    I have many worksheets of data with over thousands and thousands of records.
    I am trying to create a macro which will put a bottom border under the entire row of the last duplicate name in column A (creating a visual separation of like records). I would also like the records to have a group number to indicate they are in the same group in column L.

    Is there an easy way to do this? The manual process is mind numbing.

    I've attached an excel doc to help clarify. I've done two of the example groups manually to show what it is I am trying to accomplish.

    Thanks so much in advance. This will really save me eons of time.


    wace
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: macro to underline groups of data based on exact duplicates in column A

    Select all your data with A4 the active cell.

    Home tab, Conditional Formatting, New Rule, Use a formula .... Paste =countif($A5:$A$26, $A4)=0 as the formula, press the Format button, and set the bottom border.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-19-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2011
    Posts
    37

    Re: macro to underline groups of data based on exact duplicates in column A

    Hi shg,

    Thanks for this! But is there a way to have the groups numbered in column L? so if the value in column A are the same they would have the same group number?

    The original attached workbook has an example.

    Thanks so much - I didn't think about the conditional formatting.

  4. #4
    Registered User
    Join Date
    03-19-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2011
    Posts
    37

    Re: macro to underline groups of data based on exact duplicates in column A

    Hi - I figured it out!

    Thanks,

    Wace

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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