Sequential Numbering of Unique Records

[shedboyxx]

Hi folks.

I have a list of 347 CD's.
Each CD has a unique title.
Each CD has multiple tracks (12-99)
I've created an in place filter of Unique Records only

I have to create sequential CD codes (A0001, A0002, A0003, etc) for each title.

After filtering, when I try to just drag down in the CD Code column, I get all '1's (A0001, A0001, etc.)

Is there a quick way for me to number each unique CD Title?

TIA

Jim

 

[jim may]

Enter into Cell A1 and Copy, then Drag-Down Pasting...

Excel Workbook
	A
1	A0001
Sheet1

Excel 2007

Cell Formulas
Range	Formula
A1	="A" & TEXT(ROW(),"0000")

 

[shedboyxx]

Thanks for your quick response Jim.

Unfortunately it gives me the row number - not sequential numbering.

When the list is filtered for Unique records only the row numbers jump around.

<table border="0" cellpadding="0" cellspacing="0" width="112"><colgroup><col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:84pt;word-wrap: break-word" height="20" width="112">A0002</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">A0047</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;word-wrap: break-word" height="20">A0095</td> </tr> </tbody></table>

I'm looking for

A0001
A0002
A0003

Independent of whatever actual row the unique record lives on.

Thanks anyway!

Jim

 

[jim may]

After applying Formula - do a Copy, and Paste-Special Values (maybe)..

 

[shedboyxx]

Tried that and it just returns a pasted value of an incorrect #.

AFAIK It's because the formula is creating a number per the Excel row so pasting it just includes that # - unless I'm missing something?