View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joel Joel is offline
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!!