U R 2 naive! Here's the method

Add a column. Fill the 1st cell with "1", 2nd cell with "6". Drag copy to all 2000 rows so that the column is filled with 1,6,11,16,21......9996. In Rows 2001 through 2004, enter 2,3,4,5 respectively. In Rows 2005-2008, enter "=X2001+5" where X is the added column. Copy cells in 2005-2008 to 2009 through 10000. Copy the whole column and paste value over itself. Sort on the added column and then delete it. Now are you happy?

所有跟帖： 

• You are so great, -I'mnaive.- ♀ (0 bytes) () 12/20/2004 postreply 17:03:12

• 回複：U R 2 naive! Here's the method -cg333- ♀ (248 bytes) () 12/20/2004 postreply 19:02:38

• 你所謂的那些ITguys不過是些略通高科技的藍領工人，鍾點工 -ComeInside- ♀ (267 bytes) () 12/20/2004 postreply 21:19:51

• A macro can fix this easily! -ITguys1- ♀ (0 bytes) () 12/20/2004 postreply 22:27:03