Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula, one field complex or multiple table field simple
Please comment on whether it is best, (execution speed wise), to reach a complex result built by having a complex formula broken down into simpler sequential multiple simple formula fields with each field using the value of a previous field in its calculation and then the final field containing the complex result OR if whether it is best to use one field with a very complex formula to reach the same result?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula, one field complex or multiple table field simple
on 2/12/2012, DbMstr supposed :
Please comment on whether it is best, (execution speed wise), to reach a complex result built by having a complex formula broken down into simpler sequential multiple simple formula fields with each field using the value of a previous field in its calculation and then the final field containing the complex result OR if whether it is best to use one field with a very complex formula to reach the same result? Breaking things down into smaller pieces so you can have individual results for each piece will definitely require more processing. In this context the answer is that it's better (performance-wise) NOT to invoke extraneous processing whenever possible. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
Creating a Calculated Field in a Pivot Table for same field | Excel Discussion (Misc queries) | |||
sum a pivot table field as a calulated field | Excel Discussion (Misc queries) | |||
Calculated field in pivot table, simple Average formula | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) |