Results 1 to 4 of 4

Handling Non-Unique Cell Values

Threaded View

aharmon426 Handling Non-Unique Cell... 10-13-2009, 03:34 PM
GuruWannaB Re: Handling Non-Unique Cell... 10-13-2009, 03:45 PM
TonyS Re: Handling Non-Unique Cell... 10-13-2009, 07:02 PM
aharmon426 Re: Handling Non-Unique Cell... 10-13-2009, 08:07 PM
  1. #1
    Registered User
    Join Date
    10-13-2009
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003
    Posts
    2

    Handling Non-Unique Cell Values

    I have attached a sample spreadsheet. I'm looking for a macro that will take column one which contains Company names which are sometimes duplicated and append an incremental number based on the number of occurrences to the end of the company forcing it to be unique. Column 2 has the example of the results I would like to see. Has anyone got a macro that I could use that would allow me to select the company column, run the macro, and it update the values in that column to append the incremental number?
    Attached Files Attached Files
    Last edited by aharmon426; 10-13-2009 at 08:12 PM.

Thread Information

Users Browsing this Thread

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

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