| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Numbers, with Friends, by Formula?
Hello,
I am trying to sort a column of numbers, that are not in order, into another column. I have used this formula naming the range Rolls, to sort the numbers ascending (straight out of Excel Formulas 2003): =IF(ISERR(SMALL(Rolls,ROW(INDIRECT("1:"&ROWS(Rolls ))))),"",SMALL(Rolls,ROW(INDIRECT("1:"&ROWS(Rolls) )))) This works great, But......There is another column of data associated with these numbers, which is the adjascent cell to each number. Is there a way to sort the numbers and take the adjascent cell with them? I can use as many columns as i need, but i can't figure it out. I am having a lot of trouble with this one, in which a macro cannot be used. Nice to be back here! Thanks for any help! Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula For Sorting Part Numbers | Excel Worksheet Functions | |||
| Why can't I open any email jokes that friends send me with excel | New Users to Excel | |||
| Need help to maintain Yahoo messenger friends. | Excel Discussion (Misc queries) | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Friends: Please guide me | Excel Worksheet Functions | |||
Threaded Mode
