+ Reply to Thread
Results 1 to 2 of 2

Identifying duplicate values in a row, and change the value with them

  1. #1
    Registered User
    Join Date
    04-28-2016
    Location
    Hong Kong
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Identifying duplicate values in a row, and change the value with them

    I am having multiple rows of number, I want to find any duplicate cells in EACH row (always start at column D but does not have same number of columns for each row) using VBA, and for each duplicate value cell I want to change its value, say a rand() or I'll further do some coding, but I also want to make sure it won't duplicate again after the change. What should the code be look like?

    Sorry for my bad English.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Identifying duplicate values in a row, and change the value with them

    Hi and welcome to the forum.

    It's impossible to say given your description. You'll need to upload the workbook and manually add the results that you expect to see so that we can see the original data and the end result.

+ 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. Identifying only the Duplicate using a formula.
    By jrc272 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2014, 01:16 PM
  2. [SOLVED] Identifying Duplicate Values (2nd, 3rd, and 4th occurance)
    By Montoro22 in forum Excel General
    Replies: 2
    Last Post: 07-31-2013, 11:30 AM
  3. change all duplicate values..............
    By sanjoy.dutta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2013, 10:31 AM
  4. [SOLVED] Help needed! Identifying duplicate values with functions
    By PdubNZL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-14-2013, 08:19 PM
  5. Identifying duplicate lines using multiple values
    By dantray in forum Excel General
    Replies: 8
    Last Post: 02-09-2012, 10:51 AM
  6. Identifying Range of Different Duplicate Values
    By stonegwene in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2011, 02:05 PM
  7. Excel 2007 : Identifying Duplicate Records
    By markdtp in forum Excel General
    Replies: 1
    Last Post: 03-04-2011, 09:18 PM

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