How can I sort data in sequence by odd/even numbers

G

Guest

I am trying to sort data by street, then number, but I want to keep the odd
and even street numbers together rather than having them merged together
 
D

Dav

I would create a sorter column and use the expression =iseven(cell
containing number) eg iseven(a2) and copy this down. You can then sort
by this column and then by the house number column.

You will still have problems if an address is:
a house name
a flat
of the form 24a
etc
As none of the above are numbers

Regards

Dav
 
G

Guest

Dav answered to use =iseven

When I attempted to do this I was unable to do so, as it said that funciton
was not available. I then followed instructions and went to Tools, Add-ins,
Analysis ToolPak

Then I receive the response that Excel cannot run the add-in as it is not
installed and asks if I want to install it.

When I click on Yes, I then receive the response that Microsoft Excel cannot
access the file "analys32.xll" and says there are several
possibilities..........

What now?
 

Ask a Question

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.

Ask a Question

Similar Threads

odd and even addresses 3
how to sort addresses in microsoft excel 2
how can i sort on a perticular column for odd and even numbers 3
Sort 2 columns similtaneoously 2
SORTING BY ODD OR EVEN NUMBERS 1
Why Excel Does not increment by 2 or 3, odd/even numbers? 6
Query or Report? Need to get addresses by odd or even numbers 10
Sort by even and odd digits and copy to separate worksheet 3

Top