Basically, all I want to do is add a new column to my data after filtering it according to a specific criterion, then add a series of integers to that column, one for each row. I.e., the information in one column looks like this:
And I want a new column running next to it so it looks like this:
1 Armstrong, John
2 Beattie, Jane
3 Coombs, John
I have tried inputting the first few numbers and then dragging them down to fill the rest of the column but when I do that all of the numbers turn to 1 for some reason.