Assigning rank or appearance
I have a data table something like this but much larger.
Currently column C is empty. I want to return next to each item what
position it is. i.e. in line 3, apple has appeared once already, so the value
should be 2.
Any ideas???
ColA ColB ColC
Apple 34 1
Orange 42 1
Apple 85 2
Apple 54 3
Orange 24 2
Peach 87 1
Peach 91 2
Orange 75 3
|