If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Generate an Index Column
How can I quickly get an index column running from 1 to
(end of data)? I need this for sorting spacey data and getting rid of the blank lines. Then I restore the original order with a sort on the index column. Now I can only generate the column with an autofill drag - takes a long time. |
#2
|
|||
|
|||
Generate an Index Column
Hi
one way: if you want your index in column A (your data is in column B) try the following: - enter a 1 in A1 and a 2 in A2 - now select A1 AND A2 - double click on the lower right corner of this selection -- Regards Frank Kabel Frankfurt, Germany "Evan" schrieb im Newsbeitrag ... How can I quickly get an index column running from 1 to (end of data)? I need this for sorting spacey data and getting rid of the blank lines. Then I restore the original order with a sort on the index column. Now I can only generate the column with an autofill drag - takes a long time. |
Thread Tools | |
Display Modes | |
|
|