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

Is it something like the attached?

Attached Files

MKKYB.xlsx (10.3 KB, 12 views)

Thanks, yes something like that. Thanks for your help