Order/Step in a list of actions

[z3115]

I've got a dataset with the following columns:

UniqueID | Date | Action

[Ex: U123 | 12/1/16 | purchased widget]

I need a formula to put in each row that will tell me what step it is for that unique id. I the example above, if "purchase widget" was the 5th thing U123 did, the formula would return "5".

I thought maybe I could use an array function with SMALL and IF, but haven't been able to find a way to make it work. Thanks!

 

[z3115]

So ending up finding a work around, not the most eloquent solution but it worked:

I sorted my data chronologically (oldest to newest) then used a COUNTIFS formula:

=COUNTIF($A$2:A2,A2)

(The first cell in the range is locked, the second cell is not, so as you drag the formula down the range ends up being the current row and every cell above it)