Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Can references (to cells being sorted) move with the cells?
Right now, if I sort a range of cells, and some other cell is referring to
one of these cells being sorted, the reference doesn't move with the cell (i.e., if cell A1 is a function of cell C3 and I sort column C, then if the contents in C3 move to, say, C5, A1 will still be a function of cell C3 and not C5 like I would hope). Thanks! |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Can references (to cells being sorted) move with the cells?
Could be your formulas are using Absolute cell references.....ie: those with
the dollar signs, like $C$3, instead of just C3......if so, change them and notice the difference. Vaya con Dios, Chuck, CABGx3 "Zack" wrote: Right now, if I sort a range of cells, and some other cell is referring to one of these cells being sorted, the reference doesn't move with the cell (i.e., if cell A1 is a function of cell C3 and I sort column C, then if the contents in C3 move to, say, C5, A1 will still be a function of cell C3 and not C5 like I would hope). Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Sorting cells: a list behind the cells do not move with the cell | Excel Discussion (Misc queries) | |||
Referencing to cells in a sorted list | Excel Discussion (Misc queries) | |||
in excel paste images to specific cells that can be sorted | Excel Discussion (Misc queries) | |||
How do I change how cells are sorted in an excel file? | Excel Worksheet Functions |