[Excel 2013] I have a large list of items and I want to add a preference number to every row manually based on my preference. Example below:
Value Preference
Row1 6
Row2 _
Row3 2
Row4 _
Row5 3
Row6 1
Row7 5
Row8 4
Currently, I choose the row and add the preference number manually. This gets tiring especially as I go to 3-digits. I want excel to help with auto-incrementing in any row I choose. For example, I choose Row4 next, and 7 should be inserted as Preference. And then, if I choose Row2, 8 should be inserted as Preference.