If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to succesfully sort column of formulas?
I am trying to sort a column of formulas that consist of cell
references. Example: Column: Cell 1 holds: =D10 Cell 2 holds: =D11 Cell 3 holds: =D12 Data: D10=1 D11=2 D12=3 When I try to sort the column of formulas, the formulas change cell references to other cells and mess up the data. How can I sort a column of cells of which all of them contain formulas and have the cells keep the references to the right place? --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
How to succesfully sort column of formulas?
Hi-
If you write your formulae with absolute references rather than relative references, you can sort them. Formulae should look like =$D$10 --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Urgent Project, Please Help: Copying Formulas | Frank Kabel | Worksheet Functions | 2 | May 27th, 2004 07:50 PM |
Setting up a Command Button to sort | Frank Kabel | Worksheet Functions | 2 | May 22nd, 2004 06:24 PM |
How do I alphabetize a column but also have the corresponding cells move with the sort? | Back to College | Worksheet Functions | 0 | February 15th, 2004 02:21 PM |
Excel functions help...additional | Sothear | Worksheet Functions | 1 | February 6th, 2004 06:41 PM |
Alphanumeric sort with mixed numbers | David Kingsworthy | Worksheet Functions | 1 | September 26th, 2003 05:51 PM |