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

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=513522

Thanks,

"TxBlackJack" wrote:

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

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?

"TxBlackJack" wrote:

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