I am importing data automatically into a spreadsheet from a database
and I need to give serial numbers to each row of data. So for example
I am importing in a bunch of product data such as product number
description etc. from a database. I want to know how to automatically
add a sequential serial number into another column for the number of
rows imported in. So the final resut woult look something like this


Product Number Description Serial number
3849284 Waffle Iron 10000
8489298 Skillet 10001

So on and so forth with the serial number column increasing for each
row of data imported.

=IF(A1<>"",--TEXT(ROW(1:1)+9999,"######"),"")


"BlackJackal" skrev:

> I am importing data automatically into a spreadsheet from a database
> and I need to give serial numbers to each row of data. So for example
> I am importing in a bunch of product data such as product number
> description etc. from a database. I want to know how to automatically
> add a sequential serial number into another column for the number of
> rows imported in. So the final resut woult look something like this
>
>
> Product Number Description Serial number
> 3849284 Waffle Iron 10000
> 8489298 Skillet 10001
>
> So on and so forth with the serial number column increasing for each
> row of data imported.
>
>