+ Reply to Thread
Results 1 to 2 of 2

How do you find and tag/code duplicate cells?

  1. #1
    Registered User
    Join Date
    05-01-2019
    Location
    Bude, England
    MS-Off Ver
    excel
    Posts
    1

    How do you find and tag/code duplicate cells?

    I have created a simplified version of my problem and attached... an image of the table as the attach button is not working (apologies if the image doesn't work either).

    I have 5 product types of which have multiple length variants. Some of these variants are repeated across types. I want to manually label the first occurrence of a length with a product code and then use a formula to source all duplicate lengths and input the same product code beside them. Lengths which haven’t been ladled with a product code yet should remain blank. The layout of the table should remain the same.
    The example shows the first instances highlighted in green with the code input manually. However, the red code should be calculated by a formula.

    I’ve been trying to use an INDEX & MATCH formula and I feel like I’m heading in the right direction but I keep stumbling.

    I hope somebody can help!

    2019-05-01 13_23_13-Excel Duplicates Query Example.xlsx - Excel.jpg

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: How do you find and tag/code duplicate cells?

    Attach a sample workbook
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VB Code to find duplicate and delete row
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2015, 05:35 PM
  2. VBA Code to find duplicate in worksheet
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-02-2015, 06:33 PM
  3. VB Code to find duplicate in a column and delete he row
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-17-2014, 11:59 PM
  4. VBA code to find duplicate cells in a column, then perform a function
    By under00c in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2013, 08:19 AM
  5. [SOLVED] Code to find duplicate colors and keep only 1 entry
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-16-2013, 12:57 AM
  6. Find duplicate text in cells in column, then give names of cells containing duplicate text
    By spelunkerforlife in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 10:13 AM
  7. Detect/find Duplicate Values In Code
    By FRIEL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2008, 11:02 AM

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