| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by numbers w/ words in the same cells
I'm trying to sort a grid that ranks 5 rows from lowest to highest based on
the dollar amount in column D. Columns A-I all have different info in them. In column D, the values going down a $6342 yrs 1-6; $4286 yrs 7+ $6346 $6641 $7519 $11426 I want to sort columns B-I (as they are ranked 1 thru 5 in column A) and use the values in column D as the basis for it. But when I sort, it automatically puts the cell w/ the extra verbiage in it ("yrs 1-6...") at the bottom, even though the dollar amount is the lowest. How can I sort by just the first full number? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding most common occurence of values in cells containing letters and numbers | Excel Worksheet Functions | |||
| summing cells with text and numbers | Excel Worksheet Functions | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Sorting a range of cells that get value from other cells | Excel Discussion (Misc queries) | |||
Threaded Mode
