Ordering Problem

  • Thread starter Thread starter JD
  • Start date Start date
J

JD

I made a column Index using data from three other colums of the spreadsheet,
and put it in outline form, separating them with decimals. (#.#.#) When I
sort them in ascending order, I get problems like the example shown below.

1.11.110
1.11.111
1.11.113
1.11.152
1.11.38

I want the last one to be above at the top of the list, Excel things it
should go on the bottom because of the 3. Is there a way to fix this?
 
Hi JD,

I am assuming that these are number and periods, not formatting?

=LEFT(A1,FIND(".",A1,FIND(".",A1)+1))&RIGHT("00"&MID(A1,FIND(".",A1,FIND(".",A1)+1)+1,10),3)

This formula only deals with the last group, you may still have problems if
your second group, .11., is .2., that is, only one digit.
 
Yeah, the middle column would still be messed up. Is there a way I could
just add zeroes to the front of the numbers in the colum that the index is
using?
 

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

Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Invert data order 3
VBA- Excel Programming:- 0
Place numbers in ascending order 2
Sort Order? 1
Reverse Order 1
Excel: keeping rows together when ordering order of left column 1
How to sort names in alphabetical ascending order? 7

Back
Top