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.- 给 I'mnaive. 发送悄悄话 (0 bytes) () 12/20/2004 postreply 17:03:12

回复:U R 2 naive! Here's the method -cg333- 给 cg333 发送悄悄话 (248 bytes) () 12/20/2004 postreply 19:02:38

你所谓的那些ITguys不过是些略通高科技的蓝领工人,钟点工 -ComeInside- 给 ComeInside 发送悄悄话 (267 bytes) () 12/20/2004 postreply 21:19:51

A macro can fix this easily! -ITguys1- 给 ITguys1 发送悄悄话 (0 bytes) () 12/20/2004 postreply 22:27:03

请您先登陆,再发跟帖!