+ Reply to Thread
Results 1 to 9 of 9

Need to highlight a row that is duplicated

  1. #1
    Registered User
    Join Date
    11-24-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    12

    Need to highlight a row that is duplicated

    Hi all need help setting a rule and have no idea how to do it but know that it is achievable.

    I get sent a spreadsheet daily and it consists of names and address of customers that i visit.

    What I do is copy and paste the spreadsheet i recieve daily into a main spreadsheet with previous entries.

    It looks a little like this:

    AM MISS Jennie newton #07949087357 12 Mountwood
    AM MRS Shaheen Zaman Khan #02036241594 121 Manor Road North
    AM MISS Zakiyya Devaney #02083914847 29 Thrigby Road
    I need it to recognise if i have been the before and highlight the row in a colour automatically when i copy and paste each days work in.
    thanks russell

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,117

    Re: Need to highlight a row that is duplicated

    Hard to determine from your data displayed if all information is in one cell or spread across several columns. Are you looking for duplicate names? or must the row be duplicated in its entirety if data is spread across several columns? Also, is there a concern or issue about Capitalization? A little more detail please. Would also be helpful if you posted a spreadsheet wish a bit of sample data.

    Alan
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-24-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Need to highlight a row that is duplicated

    hi alan each one is in its own cell so names in one addresses in another phone number in another all i need is it to spot any off the cells that are duplicated wether that be there name address or there phone number. thanks

  4. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Need to highlight a row that is duplicated

    Well, if your data starts in row 1, and the numbers (#07949087357) are in column D, then highlight all of the cells across the rows with data and down to the bottom of your list and apply this formula for conditional formatting:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I went with basing the CF off of the #'s because there may be duplicates in other fields.

    -Moo

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,037

    Re: Need to highlight a row that is duplicated

    Hi,

    Is this the answer to your problem?
    http://office.microsoft.com/en-us/ex...001136616.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  6. #6
    Registered User
    Join Date
    11-24-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Need to highlight a row that is duplicated

    Will that highlight the whole row ? as there is data in that row that matches a previous row.

  7. #7
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Need to highlight a row that is duplicated

    It will highlight any row where there is a duplicate #xxxxxxxxxxx. Provided you assigned the formula to the correct column (the column that the #'s are stored in).

    - Moo

  8. #8
    Registered User
    Join Date
    11-24-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Need to highlight a row that is duplicated

    Hi marvin in a way yes but this is cell specific I need it to look from top of a selected colum say F and see if any data from top to bottom duplicates. What you sent me will show a duplicate but you have to pick a cell first then it will look through to see if any of the other cells in that coloum match. do you have any other thoughts please. thanks
    Last edited by jeffreybrown; 11-24-2012 at 01:11 PM. Reason: As per Forum Rule #12, don't quote whole posts unless necessary-- it's just clutter.

  9. #9
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Need to highlight a row that is duplicated

    russellhiedi:

    My conditional formatting formula is exactly the one that is used on that linked page. If you need to look in column F instead of column D, then highlight the array of cells, open the Conditional Format dialog, and change the formula to this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    - Moo

+ 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