I regret my ignorance but I simply don't understand.
You write that the formulas you are using are located at X2:AE16 (Master Data) but I can't see what the formulas are referring to (=MAX(#REF!) for example).
Is it formulas in X2:AE16 you want help to or is it something else? If it is what range(s) should the formulas use.
I will do what I can trying to help but I need more help from you to understand what it is that you want.
|