 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006How to sort with fractional
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  SignatureTaGY2K 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. SignatureHTH Sandy In Perth, the ancient capital of Scotland sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > Hi, I am just wonder how to sort the colum with all the fraction on top > or bottom ...ie.. [quoted text clipped - 10 lines] > 21.75 > 54.375 Thanks ... it work... I am just wonder what is a good book to read on stuff like this? SignatureTaGY2K 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 SignatureHTH Sandy In Perth, the ancient capital of Scotland sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > Thanks ... it work... I am just wonder what is a good book to read on > stuff like this?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.