+ Reply to Thread
Results 1 to 5 of 5

Bordering data that is the same

  1. #1
    Forum Contributor
    Join Date
    02-10-2013
    Location
    Wolverhampton
    MS-Off Ver
    Excel 2010
    Posts
    101

    Bordering data that is the same

    Hi, I have almost 6000 records, (see file attached), it contains first diagnostic codes in column a, second in column b, and third in column c. If the rows are the same (i.e. all three diagnostic codes match), then I want to border the data ('outside borders'), because I have so many records is there a quick and easy way to do this?

    I would really appreciate your help.diagnostic codes.xlsx
    Last edited by nav505; 05-31-2013 at 02:15 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Bordering data that is the same

    What is the desired result?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    02-10-2013
    Location
    Wolverhampton
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: Bordering data that is the same

    To clearly distinguish which rows are different

  4. #4
    Forum Contributor bentleybob's Avatar
    Join Date
    02-27-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    644

    Re: Bordering data that is the same

    Does this work for you? Note that if you really want to distinguish these rows, I would suggest you change the color as well.
    Attached Files Attached Files

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Bordering data that is the same

    There isn't any data in your file that matches your criteria so I made row 10 match.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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