To do this manually, just create a list of numbers in column C ie 1, 2,
3 down the page. Then sort by one of the first 2 columns. Delete the
rows at the bottom, then sort by the column with the numbers.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561376