Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort a column of formulas
Suppose I have ten numbers in cells A1 - A10. In cells B1 - B10, I have
formulas, each one referring to the neighbor cell in column A. I want to sort column B ascending without touching column A. For example, if the smallest value was in B6, I want the formula in B6--including its reference to A6-- to be transferred to B1, etc. I tried doing this in my Excel 2000 and it did not work. Should it? If yes, what could be the problem? If no, is there another way to achieve the same result? Thanks. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |