--- In [email protected], "brian_z111" <brian_z...@...> wrote: > > Dare I 'suggest' that custom autocomplete, in FormulaEditor is the > best 'one size fits all' solution then? > > Example: > > I could use a custom 'macro' so that when I write; > > Pivot = > > the ForumlaEditor completes; > > Pivot = Ref(H + L + C,-1)/3; > > OR > > Pivot = (H + L + C,-1)/3; > > OR for dummies like me: > > Pivot = (Ref(H,-1) + Ref(L,-1) + Ref(C,-1)/3; >
This should be: Pivot = (Ref(H,-1) + Ref(L,-1) + Ref(C,-1))/3; Thanks, Jim
