Excel formula assist in looking for sequence

Capture.PNG

Dear Experts,

With reference to the attached table, is there any excel formula that could assist to find the 10th number after Number 1 in Column A (which is 14).

I would greatly appreciate if you could assist on this. Thank you!


Regards,
Brian

Try:

Please Login or Register  to view this content.

Capture.PNG

Hi Melvosh, Thank you so so so so much for helping!

Is there any formula to make it restarts from Number 3 in Column A in order to avoid reference error problem? For instance, the 10th number of Number 12 in Column A returns an error, unless there is a formula to make it restarts from or includes Number 3 in Column A.

Thank you!

Relative to your picture in post #3, here is a mod (excuse the pun) to Melvosh's formula:

Try the following in C2 copied down and across:

Formula:

Please Login or Register  to view this content.

WOW...I never thought that this can be done! Thank you so much GeoffW283 and Melvosh!

Hi AliGW,

Noted and thanks!