Sort Data by Odd (ascending) and Even (descending)

[tutu1201]

I have a list of voter registration data and am trying to sort it into a "walking list;" i.e., 1 side of the street with ascending numbers and the return side descending numbers so that I can walk 1 side then, without going back to the beginning end, walk the other side back to my car). I will not necessarily be stopping at houses without voters so just walking won't work.

I have done this before (years ago) in Visual dBase but never in Excel. I know it'll work just can't figure out how! I've sorted out street name from house number and can get started that way, but am having nothing but trouble performing the sort!

Any help?

 

[hiker95]

tutu1201,

Can we see some of your data?

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[WaterGypsy]

If you are stripping out the house number already I assume its going into a separate cell - why not make that cell say "Odd 1" or "Even 2" then you can just sort normally ?

 

[Gerald Higgins]

You could also do something like

=if(iseven(a1),a1,a1+1000000)

and sort on that.

 

[tutu1201]

<a href="http://www.grant4da.info/Capture.JPG">Link to Pic</a>

 

[hiker95]

tutu1201,

You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt you'd get any answer.

Where to upload Excel files so threads don't take 20+ posts to get the correct answer from guessing:
MediaFire: http://www.mediafire.com/
FileFactory: http://www.filefactory.com/
FileSavr: http://www.filesavr.com/
FileDropper: http://www.filedropper.com/

Or, you can upload it to www.box.net and provide us with a link to your workbook.

 

[Gerald Higgins]

tutu1201, I agree with hiker, but I've had a look at your picture and it seems fairly obvious that my suggestion, or WaterGypsy's, SHOULD work.

 

[tutu1201]

tutu1201,

Can we see some of your data?

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

Sorry. When you asked for a "screen shot" that meant pic to me. I'll see what I can do to post data.

 

[tutu1201]

tutu1201,

You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt you'd get any answer.

Where to upload Excel files so threads don't take 20+ posts to get the correct answer from guessing:
MediaFire: http://www.mediafire.com/
FileFactory: http://www.filefactory.com/
FileSavr: http://www.filesavr.com/
FileDropper: http://www.filedropper.com/

Or, you can upload it to www.box.net and provide us with a link to your workbook.

Here's the file: http://www.mediafire.com/file/wxkmmzzw0tz/Book1.xlsx

Thanks to all for any help.

 

[Gerald Higgins]

Have you tried the suggestion that I offered, or WaterGypsy's ?
I'm assuming you have, and they're not right for you in some way.
So, what's wrong with them exactly ?