sorting problem 10 comes before 8

  • Thread starter Thread starter ty
  • Start date Start date
T

ty

When sorting a list in a column where some are single digits and some are
such as :
1
3
8
8 x 12
10 x 10
they sort as follows
1
3
8
10 x 10
8 x 12
single numbers are fine but once you hit the ones with the x (to show
measurements) the 1 in the 10 x 10 comes before the 8. It does not help to
make it text.
Any thoughts
 
You need a helper column. Assuming your list starts in A1, enter this in B1
by using ctrl+shift+enter, then fill down, then sort on column B:
=1*LEFT(A1,MATCH(TRUE,ISERROR(1*MID(A1,ROW($1:$10),1)),0)-1)

Bob Umlas
Excel MVP
 
Bob one question, as it is an array formula how can I copy it down?

thanks
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Bob Umlas" escreveu:
 
Back
Top