Sorting Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an Excel 2003 worksheet for Bill Of Materials. I also you the
Worksheet in AutoCAD for Item callouts.

So my dilema is that I use a numbering convention of :

1.1
1.2
1.3
..
..
1.9
1.10
1.11
1.2
1.3

When I sort these numbers they come back sorted numerically

1.0
1.10
1.11
1.2
1.3

Is there anyway in Excel to sort these with out cutting and pasting the
items in place.
 
Hi,
One solution - insert a "sort" column to the left or right of your numbers
column. Number those cells from 1 to whatever and use it to sort. You can
hide the column if you don't want it showing.
 
hi,
I usually handle oddball sorts like that with a helper column then use that
as my first sort but i am not sure how much extra work for you this might be.

example>
1.1 = 1
1.2 = 2
1.3 = 3

1.9 = 9
1.10 = 10
then sort by the helper column,

regards
FSt1
 
Back
Top