Adding Data Automatically
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. |
Adding Data Automatically
=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. |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com