| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do formulas in a table translate when sorted?
I have a table in excel that has formulas in the rows. When I sort the
table, the addresses in the formulas do not translate to the new location after the sort. I am not using absolute addressing. This is confirmed because the address do translate when I drag them to the next row. How can I make the addresses translate after sorting? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Do formulas in a table translate when sorted?
Nothing built will take care of that, there are some workarounds here
http://www.mvps.org/dmcritchie/excel/offset.htm -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Matt@Major" wrote in message ... I have a table in excel that has formulas in the rows. When I sort the table, the addresses in the formulas do not translate to the new location after the sort. I am not using absolute addressing. This is confirmed because the address do translate when I drag them to the next row. How can I make the addresses translate after sorting? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking table in Excel to word | Links and Linking in Excel | |||
| formulas to numbers | New Users to Excel | |||
| How do I add another name to an existing table with formulas to w. | Excel Worksheet Functions | |||
| Pivot Table - Custom Formulas | Excel Discussion (Misc queries) | |||
| Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions | |||
Linear Mode
