Repetitions consecutive numbers

[febausa]

Hello, please help in appropriate formula

 

[NARAYANK991]

Hi ,

See if this is acceptable.

Narayan

 

[John Jairo V]

Hi @febausa (and @NARAYANK991)

Please see another option. Comment! Blessings!

 

[febausa]

Hi @febausa (and @NARAYANK991)

Please see another option. Comment! Blessings!

John Jairo V. :
Your formula is great, thank you .
Your formula no working in my sheet, please help me in fix the problem.
I attached the sheet resume, show the problem.

 

[NARAYANK991]

Hi ,

The formula is an array formula , which is supposed to be entered using CTRL SHIFT ENTER.

Narayan

 

[febausa]

Hi ,

The formula is an array formula , which is supposed to be entered using CTRL SHIFT ENTER.

Narayan

NARAYANK991:

Thank you.

You and John Jairo V. are true excel GURU.