I would like help with what I call an optimised result from an average formula.
Can an average result be multiplied automatically to return an optimised number?
So for example, if the straight average of the b column in c5 was multiplied by 3.9 it would return an optimised number (B4) which can then be fed into a2's formula. The aim of this would be to produce the highest figure possible in the a2 cell from the data in A & B. Can c5 'look' at a2 then multiply itself to return the highest figure for a2 ?
Thanks in advance.
Alex G
Alex G - a few have looked at this (self included) and lack of response generally means people are struggling to follow the requirements.
Using your sample file ... which calculations are incorrect and / or require modification and why ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
DonkeyOte
Thanks for the reply. I'm trying to extract the highest figures from a set of data using this method. Doing this manually gives me, for the most part, a very useable figure.
Ok - A2 has a formula that filters/replaces figures that are 9 or higher than 9 with 9 (B2) by looking at columns A & B.
If I manipulate the average B2 by multiplication I get another figure I can use to filter out lower numbers and gain a higher total A2.
A4 is a normal sum of column A. A2 filters out numbers that are 9 or higher and replaces them with 9 or whaterver the figure may be. Can A2 & B2 work together to multiply B2 and return a her figure? Manually 3.9x gets the best result. Over multiply and you basically bypass the formula in A2 and end up with A4's result.
Alex G
Last edited by shg; 05-08-2010 at 12:32 PM. Reason: deleted spurious quote
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks