I am trying to auto-number a group of records for one person in a table with multiple people listed with numbers 1,2,3, etc.. In Excel, I would use a formula to add one number to the above cell, and it would number all rows sequentially. I usually manually number each record, but I am hoping a simple formula would number the list.
Here is a screenshot of my table consisting of the records I need based on a filter. The row with # in the title is where I would put the formula. Any suggestions?