Formula for calculating sequence number in third column based upon first 2 columns

HI Arun,

welcome to the forum.
Try using below formula :-

Formula:

=SUMPRODUCT(($A$1:$A1=$A1)*1)

Regards,
DILIPandey
<click on below * if this helps>