Try this (change the ranges to suit your sheet). Of course, the brackets indicate that this is an array formula so when you enter it you need to press CNTL-SHIFT-ENTER.



{=LOOKUP(2,1/(C6:C15=C4),D6:d15)+1}

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