|
|
#1
07-22-2015, 03:26 PM
|
|||
|
|||
Cell references don't change on sort
OK...I can't attach a sheet but this seems to be a rather easy problem so perhaps my explanation will suffice.
My wife has a kludgy sheet with data from A16:AH80. In Z86 (i.e. below this table) there is a formula of mammoth kludge proportions. For the heck of it, here it it... =+N44+P30+Q44+S30+S33+T33+U34+U33+V33+W33+X17+Y21+ Y22+Y23+Z39+Y40+W38+Y42+Y43+X46+Y46+Z46+Z51+Y51+X5 1+Y52+X52+V55+Y55+W58+Y60+X63+Y64+W65+Y66+Y67+Y68+ X70+Y73+Y74+Y75+Z72+1500 The problem is, if she sorts her table, the cell references stay the same and thus the formula returns a different result based on the new values in those cells. I've never had formulas like that so I've never encountered this problem but it seems that cell references in formulas do not update with a sort. Is that truly the case? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Propagating a formula which references a named cell | Splint | Excel | 4 | 06-15-2015 04:55 AM |
| Updating document causes change lines on all cross references. :( | garybeck | Word | 2 | 05-08-2015 09:15 PM |
| Macro to change cell references | SaneMan | Excel Programming | 6 | 10-01-2013 02:49 PM |
| Formula that references cell with text in different workbook | no1texan | Excel | 3 | 07-17-2012 05:58 AM |
| quick replace, sort, change columns | userman | Excel | 1 | 05-01-2012 06:24 AM |
Cell references don't change on sort
Windows 7 64bit 
Office 2010 64bit
Threaded Mode