How to sort with fractional

[TaGY2K]

Hi, I am just wonder how to sort the colum with all the fraction on top
or bottom ...ie..

54.375
377
21.75
87

to be like this..

377
87
21.75
54.375

 

[Sandy Mann]

One way would be to used a *helper* columns, (insert one if necessary)

With the original data in Column A enter the formula in B1:

=IF(MOD(A1,1)>0,1,0)

and copy down. Then sort on Column B - assending, then by Column A -
assending to give the result you want.

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[TaGY2K]

Thanks ... it work... I am just wonder what is a good book to read on
stuff like this?

 

[Sandy Mann]

I omitted to say, but then you probably know anyway, that once sorted you
can delete the *Helper* Column.

As to books, you could try:

http://j-walk.com/ss/books/index.htm

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk