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?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
