How to sort with fractional

T

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
 
S

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

[email protected]
[email protected] with @tiscali.co.uk
 
T

TaGY2K

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