Sorting numbers with brackets
 

Hi - Hope someone can help.

I have a set of numbers, eg

00012
00013(2)
00014
00010(2)

I need to be able to sort these, ignoring the numbers in brackets. At
the moment, the numbers with brackets appear at the end of the list,
and this is causing me problems as I need the numbers themselves to be
in order, but I still need the brackets to stay there.

I have tried changing the format of the column, but cant get there.
:confused:

Any advice/help welcome

Thanks


--
Itsy
------------------------------------------------------------------------
Itsy's Profile: http://www.excelforum.com/member.php...o&userid=26005
View this thread: http://www.excelforum.com/showthread...hreadid=393660

One play to try ..

Assuming the data is in col A, from row1 down

Put in B1:
=IF(ISERROR(LEFT(A1,SEARCH("(",A1)-1)),A1,LEFT(A1,SEARCH("(",A1)-1))
Copy down

Then sort both cols A & B, by col B (ascending or descending)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
Sample files at: http://savefile.com/projects/236895
xdemechanik
---
"Itsy" wrote in message
...

Hi - Hope someone can help.

I have a set of numbers, eg

00012
00013(2)
00014
00010(2)

I need to be able to sort these, ignoring the numbers in brackets. At
the moment, the numbers with brackets appear at the end of the list,
and this is causing me problems as I need the numbers themselves to be
in order, but I still need the brackets to stay there.

I have tried changing the format of the column, but cant get there.
:confused:

Any advice/help welcome

Thanks


--
Itsy
------------------------------------------------------------------------
Itsy's Profile:
http://www.excelforum.com/member.php...o&userid=26005
View this thread: http://www.excelforum.com/showthread...hreadid=393660

This works perfectly.

Thanks Max - I would never have got there!!!

Cheers :)


--
Itsy
------------------------------------------------------------------------
Itsy's Profile: http://www.excelforum.com/member.php...o&userid=26005
View this thread: http://www.excelforum.com/showthread...hreadid=393660

Formatting as text worked for me, I ended up with:

00010(2)
00012
00013(2)
00014



"Itsy" wrote:


Hi - Hope someone can help.

I have a set of numbers, eg

00012
00013(2)
00014
00010(2)

I need to be able to sort these, ignoring the numbers in brackets. At
the moment, the numbers with brackets appear at the end of the list,
and this is causing me problems as I need the numbers themselves to be
in order, but I still need the brackets to stay there.

I have tried changing the format of the column, but cant get there.
:confused:

Any advice/help welcome

Thanks


--
Itsy
------------------------------------------------------------------------
Itsy's Profile: http://www.excelforum.com/member.php...o&userid=26005
View this thread: http://www.excelforum.com/showthread...hreadid=393660

Glad to hear it worked for you !
You're welcome
--
Rgds
Max
xl 97
---
Singapore, GMT+8
Sample files at: http://savefile.com/projects/236895
xdemechanik
---