I have an excel spreadsheet containing a list of names and "scores" that they have received for a specific date. Each name should have 3 scores each month and I'm looking for a formula that can help keep track of this. So for example, if John Smith has been entered 3 times in the file there will be a 1,2, or a 3 next to the instance so that I know he's reached his final score for the month. The only formula I've been able to find is to count the overall number of instances in a range - but it would just put "3" in each cell instead of which order they occured in.
Also, there are about 200 different names in the file. If there is a way to drag the formula down and have it link to the cell directly that would be better so that I don't have to type 200 individual names into the formula each time.
Can anyone give me some advice?