Hi Zack,

Maybe the rows between 1345 and 1348 are hidden. Select the rows, right
click and choose Unhide from the menu.

This maybe a possible answer to your problem.

Hope this helps,

Gav

"Zack" wrote:

After merging several worksheets and removing multiple duplicate records, I
have noticed that many rows jump in sequence (e.g. 1345-1348). For accurate
record counting, how do set my new worksheet so that the row number actually
represents the real record number?