LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Looking to add unique (sequential) number to already generated Use

Greetings All,

I have several hundred usernames that are identical (ex. 50 "mjones"). I
want to be able to use excel if possible to place a unique and sequential
number at the end of the duplicates (after the first original of course).

I was able to create a worksheet with "Concoctonate=Conditional
Formatting=True&False=Sorting"... Now just looking for a way to automate
the "adding of unique numbers" at the end of the username.... Any advice...?

Thank you!
Sawtelle
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign unique auto-generated number Silena K-K Excel Discussion (Misc queries) 0 January 28th 08 10:44 PM
Counting unique values in a list generated with the OFFSET functio mikelee101 Excel Worksheet Functions 3 December 6th 07 09:50 PM
Generating Unique Sequential Numbers Emma Winskill Excel Discussion (Misc queries) 3 June 22nd 07 10:12 PM
Qualifying a generated value as unique across worksheets jloos Excel Discussion (Misc queries) 3 August 1st 06 09:54 PM
unique sequential number excel 2000 Ches Excel Discussion (Misc queries) 0 May 13th 05 10:55 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"