with an added help column
enter 1 and 2
selectthe two cells and extend that series using the right hand bottom
corner of the second cell and hold the control button
so that you'll get 1212121212 going down
then sort the data using that column
--
Greetings from New Zealand
"Chris" <Chris RemoveThis @discussions.microsoft.com> wrote in message
news:AF46BD5B-624E-4D43-82FF-AE0528AC26E3@microsoft.com...
> Is it possible to somehow delete the odd numbered rows in an excel
> spreadsheet?
>
> My partner and I have a list of 1500 leads in an excel spreadsheet and
> want
> to split them by odd and even row numbers.
>
> Thanks,
> Chris