Posted to microsoft.public.excel.worksheet.functions
|
|
insert blank cells
Max Wrote:
One way ..
Assuming source data in A1:A10
Fill-in the series: 1,2,3, ... 10 into B1:B10
Copy the series in B1:B10, paste into B11:B20
Then select cols A and B, sort by col B ascending
Clean up by deleting col B
--
Max
Singapore
Thanks, that works great
--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570737
|