Calculate cumulative count by looking values in a column

How can I create a column "Result" below by keepin a count of repeating values from Col1?  Thanks. Col 1    Result    a              1    b              1    a              2    c              1...