Off to the side someplace, enter 1 in a cell and 2 in the cell below it.
Copy the two cells.
In an empty column, select cells 1:2000 (the data rows).
Paste (column is filled with alternating sets of 1 and 2)
Sort using the paste column as the key - descending
Delete the top 1000 rows.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"burch"
<
[email protected]>
wrote in message
Is there a simple way to do this besides CTRL and the Row everytime. I have
about 2000 lines?
