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