If you are using an Excel Table then you do not have to worry about step 4. This must be done BEFORE you sort the other columns so that the index column is included in the sort. IMPORTANT: If you are NOT using an Excel Table then you will need to reapply the filters to include this new column.Select Series from the Auto Fill Options menu to create a sequential list of numbers 1,2,3,….Checkout this article on the fill handle to learn more. Double-click the fill handle to fill the number down.Type a 1 in a blank column to the right of the data range/table.Here are the steps to create the index column: It's important to setup the index column BEFORE you apply any sorting to the data. I typically refer to this as an index column.Īfter sorting the data you can then go back and sort the index column to restore the original sort order. One way to solve this problem is to add a column of sequential numbers to the data set. If we sort one or more columns in the range, it can be difficult or impossible to revert back to the original sort order. Often times we receive a data set that does not have a column of sequential numbers or dates.
0 Comments
Leave a Reply. |