Results 1 to 4 of 4

How to find duplicate rows where columns contain data of different types

Threaded View

olechkq How to find duplicate rows... 12-07-2010, 04:48 AM
JBeaucaire Re: How to find duplicate... 12-07-2010, 04:53 AM
olechkq Re: How to find duplicate... 12-07-2010, 05:11 AM
JBeaucaire Re: How to find duplicate... 12-07-2010, 01:18 PM
  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    Latvia
    MS-Off Ver
    MS365 Version 2501
    Posts
    21

    How to find duplicate rows where columns contain data of different types

    I have an Excel file to register absences of employees, sometimes the information about absence days is duplicated. Therefore in case I enter a new row with a name AND date that already has been registered I want it to highlight that row.

    Column A - Name
    Column B - Date

    If the name and date were already registered at some point I would like to highligh this.

    Could you please advise?
    Attached Files Attached Files
    Last edited by olechkq; 12-07-2010 at 04:51 AM.

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