Hello,

I need help on converting below table (by VBA code or a Formula)

XX YY
1000 4401
1000 4402
1000 4403
1000 4404
2000 4401
2000 4403
2000 4404

Into:

XX Starting no Ending No Count Missing count
1000 4401 4404 3
2000 4401 4404 3 1

Thanks in advance for the help.

Regards,
Kiran.