Forum Discussion
Solved
Formula for multiple outcomes
Iv a spread sheet that changes daily. If things stayed in one place I can work it but as they don't I'm looking for a formula that can take in different possibilities.. today FSG (full size glass) wou...
Maybe as in the attached file.
It seems so that you have to apply array-formulas to get dynamic information about your data pool. To work with dynamic number of lines and/or columns you have to use dynamic defined named areas applying the function offset. The parameters may be fixed or dynamic defined named areas.
Good luck