Current Month Previous Month
Policy Number Premium Comm Policy Number Premium Comm
333034679 1062.46 63.94 333034679 1062.46 163.94
557100721 566.54 71.03 444231477 509.12 77.17
557017378 1251.83 156.69 555294583 1005.25 138.12
557045421 509.26 63.87 555767005 281.4 35.39
557047844 554.33 69.5 555903309 922.37 185.35
556973544 163.85 33.13 555909320 285.89 35.95
556993665 561.07 76.73 555939362 347.92 48.66
557047437 506.2 67.06 556006087 405.06 54.33
557045492 1036.39 138.67 556102175 742.62 119.71
557047054 708.23 88.93 556159926 522.42 65.51
55697378 4 41.54 5.41 556247910 1070.29 147.35
Testfile uploaded.
I want to sort this so that each month the policy info can be compared. In other words, the policy number shoud be the same in each row. Unfortunately, every month policies get cancelled and fortunately some gets added. The problem is that new policy numbers are not necessarily sequential, so it can happen that a new policy is added in the middle of list Current Month. If I the sort each month separately, the numbers match to a point and then goes haywire.
Bookmarks