LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
louannes
 
Posts: n/a
Default How do I filter a number list by numbers to the right of the decim

I need to sort a list of numbers (and their values) by the numbers to the
right of the decimal, i.e., the list has numerous values to the left (whole
numbers), but the right have only 4 or 5 and I need these segregated by the
decimals to the right in order to put them in columns. From: 600000.3019
50
600000.3030
125
600000.6000
60
602000.3019
100
602000.3030
25
602000.6000
85
To:
600000.3019 50 600000.3030 125 600000.6000 60
602000.3019 100 602000.3030 25 602000.6000 85
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I align numbers where one number has a dollar sign? Carter Devereaux Charts and Charting in Excel 1 June 26th 05 07:20 PM
Find the number of rows returned in a filter Tony W Excel Discussion (Misc queries) 5 May 30th 05 10:36 PM
making a list of numbers. toddb123 Excel Discussion (Misc queries) 3 April 21st 05 12:21 PM
How do I pick a number from a list in Excel? pugsly8422 Excel Worksheet Functions 4 January 3rd 05 06:07 PM
Lookup closest number in list Jeff Excel Discussion (Misc queries) 6 November 26th 04 07:27 PM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"