| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting data--impact to formula references and charting
Table 1 has data, and Table 2 has formulas referencing data from Table 1. If
I sort the data in Table 1, the formulas in Table 2 end up referencing the wrong cells. Is there a simple way to fix? Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Cell Data as adjustment to formula references | Excel Worksheet Functions | |||
| Creating a formula calculates time impact on achieveing sales quota | Excel Worksheet Functions | |||
| Sorting Data with External References | Excel Discussion (Misc queries) | |||
| Why doesn't the finance rate in MIRR impact the formula result? | Excel Worksheet Functions | |||
| charting cell references | Excel Programming | |||
Threaded Mode
