LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How Do I change repeating numbers in a column

Hi,

I'm creating a huge spreadtsheet for a large music collection. One of the
columns is the track number. Unfortunately some of the discs have the same
track number. I would like to figure out a way to index these numbers so
instead of track 3 reapting 4-5 times it will index to 3.2, 3.2., 3.3,
....etc.

Is there a way to do this without changing each cell individually? It would
be a huge job.

Thanks in advance for your help!!
 
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
Excel, change column of negative numbers to positive numbers? Nita New Users to Excel 3 November 27th 07 04:54 AM
Can I change a column of calculated numbers to absolute numbers? Kate Bissell Excel Discussion (Misc queries) 3 October 25th 06 06:10 PM
How can I change column numbers back to column letters? Space Elf Excel Worksheet Functions 3 March 2nd 06 09:35 PM
How do I generate random, non-repeating numbers that don't change? bsquared0 Excel Discussion (Misc queries) 1 July 30th 05 04:22 AM
Repeating a sequence of numbers down a column Nexan Excel Discussion (Misc queries) 2 March 4th 05 05:39 PM


All times are GMT +1. The time now is 12:21 PM.

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

About Us

"It's about Microsoft Excel"