+ Reply to Thread
Results 1 to 4 of 4

Changing the name of a duplicate cell

  1. 04-28-2015, 04:01 PM #1
    Brandonjay
    Brandonjay is offline
    Registered User
    Join Date
    04-14-2015
    Location
    East sussex, England
    MS-Off Ver
    2010
    Posts
    3

    Unhappy Changing the name of a duplicate cell

    Hi All,

    Im at a bit of a stump and really want to find an easy way of doing things

    Basically I have text as follows

    1012: Bobs Insurance
    2067: Bobs insurance
    3067: Travis Perkins
    2222: Travis Perkins
    1234: Travis Perkins

    I have broken this down to just the name,

    Bobs Insurance
    Bobs insurance
    Travis Perkins
    Travis Perkins
    Travis Perkins


    but I need all names showing but they cant be duplicated.

    I need it to look like this for example:

    Bobs Insurance
    Bobs insurance (1)
    Travis Perkins
    Travis Perkins (1)
    Travis Perkins (2)

    Is there any quick way of doing this, such as using the find/replace option as I have over 500 duplicate names

    many thanks

    really sorry for the poor description
    Reply With QuoteRegister To Reply
  2. 04-28-2015, 04:55 PM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Changing the name of a duplicate cell

    sth like this?

    Bobs Insurance (0)
    Bobs Insurance (1)
    Travis Perkins (0)
    Travis Perkins (1)
    Travis Perkins (2)
    John Doe (0)
    Allan Any (0)

    =INDEX($Q$1:$Q1,MATCH(Q1,$Q$1:$Q$7,0))&" ("&ROW(1:1)-MATCH(Q1,$Q$1:$Q$7,0)&")"

    edit:
    names should be sorted first
    Last edited by sandy666; 04-28-2015 at 05:14 PM.
    Reply With QuoteRegister To Reply
  3. 04-28-2015, 05:31 PM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Changing the name of a duplicate cell

    One way...

    Data Range
    A
    B
    1
    Name
    Count
    2
    Bobs Insurance
    3
    Bobs insurance
    (1)
    4
    Travis Perkins
    5
    Travis Perkins
    (1)
    6
    Travis Perkins
    (2)


    This formula entered in B2 and copied down:

    =IF(COUNTIF(A$2:A2,A2)=1,"","("&COUNTIF(A$2:A2,A2)-1&")")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  4. 04-28-2015, 05:47 PM #4
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Changing the name of a duplicate cell

    [deleted] it doesn't work
    I mixed two columns
    Last edited by sandy666; 04-28-2015 at 05:56 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cell color is not changing for duplicate values using VBA
    By kvramana82 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2013, 05:35 AM
  2. [SOLVED] Looping through column and changing duplicate values
    By rufio2004nfg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2012, 07:22 PM
  3. Duplicate formula to adjacent cells without changing cell contents that differ cell to cel
    By RP220471 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-10-2012, 04:32 PM
  4. [SOLVED] Macro to duplicate lines changing cell value
    By jdepablo69 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-02-2012, 02:41 PM
  5. duplicate changing values down a column
    By Hajik in forum Excel General
    Replies: 2
    Last Post: 02-21-2012, 01:00 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1