Thanks for getting back to me, it doesn't exactly give me what I want.

I more or less need a formula to continue a numbering sequence based on the value in the adjacent cell.
If column C has values x, y or z and D contain numbering sequence based on what is in C
so say C10= x then D10 checks for the last C cell with x value (before C10) and returns the number in the D cell +1