Line auto count formula HELP

[feign3]

I have a large (3000 records) comma delimited database file of customers. The first column has a 'record' id in it. All the id's for each customer are the same but I need to assign a unique id to EACH line. As you can imagine, I really don't want to have to manualy type in a new line id for each of the 3000 seperate lines. Does anyone know of a formula I can use on the line id column to start at 100 and automaticaly add 1 to itself to populate the line below it with?

Thanks in advance for your help!!

[Yogi Anand]

On 2002-05-16 13:58, feign3 wrote:
I have a large (3000 records) comma delimited database file of customers. The first column has a 'record' id in it. All the id's for each customer are the same but I need to assign a unique id to EACH line. As you can imagine, I really don't want to have to manualy type in a new line id for each of the 3000 seperate lines. Does anyone know of a formula I can use on the line id column to start at 100 and automaticaly add 1 to itself to populate the line below it with?

Thanks in advance for your help!!

Hi feign3:
I am going to have make some assumptions. I am going to assume that the IDs are alphanumeric text entries. So, if you want o use a formula approach, insert temporarily a column next to the column where your IDs reside -- if your IDs reside in column A, then the inserted column would be B
In B100, put the following formula:

=A100&ROW()-99

and replicate this formula down all the way to 3000 or whatever number of rows occupy your IDs

What the formula does is this ...
If you had 'abc' in cell A100, then B100 will have 'abc1'; if cell A101 had 'def', then B101 will become 'def2'

I believe this is what you wanted to accomplish -- if not please post back and explain a little further so we can take it from there.

Regards!

[feign3]

Hey Yogi,

Thanks a bunch. The line id's are all numeric but I made some simple adjustments to your formula and it worked great.

Thanks for taking the time!!

Peace.