Results 1 to 3 of 3

Highlight top duplicate cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2010
    Location
    Belgrade
    MS-Off Ver
    Excel 2003
    Posts
    19

    Highlight top duplicate cell

    Hi,
    I need help finding duplicate cells. In xls file I have two table (Table 1, Table2), both table has same columns ID1 and ID2. In Table 2 I have unique records in both columns and I need to find duplicate values in Table1 and only to higlight the top unique cell in column ID1. In attached file I manually highlighted 3 cells but I need to higlight in whole column ID1 based on a unique cell in Table 2 column ID1. Thank you
    Attached Files Attached Files
    Last edited by blade82; 09-20-2010 at 08:39 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