Here's a formula suggestion. Is this what you meant?
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:70px;"><col style="width:54px;"><col style="width:76px;"><col style="width:54px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="align: right"]SEQ NO[/TD]
[TD="align: right"]ID[/TD]
[TD="align: right"]SEQNO_I[/TD]
[TD="align: right"]ID[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]634[/TD]
[TD="align: right"]5678[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]6901[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="align: right"]358[/TD]
[TD="align: right"]16483[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: right"]496[/TD]
[TD="align: right"]19814[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]6901[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]6901[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="align: right"]358[/TD]
[TD="align: right"]16483[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="align: right"]496[/TD]
[TD="align: right"]19814[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="align: right"]496[/TD]
[TD="align: right"]19814[/TD]
</tbody>