Re: $$Excel-Macros$$ NEED HELP - GET PIVOT

2011-05-07 Thread NAJEEB JAFRI
When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks & regards On 5/6/11, mayur wrote: > Tha

Re: $$Excel-Macros$$ NEED HELP - GET PIVOT

2011-05-06 Thread mayur
Thank you all... Have a great Weekend :) On Fri, May 6, 2011 at 8:54 AM, rajan verma wrote: > Find the attached File.. > > On Fri, May 6, 2011 at 5:20 PM, mayur wrote: > >> Hi All, >> >> I need help on get pivot formula for getting average of last three days >> score. >> Please find attached she

Re: $$Excel-Macros$$ NEED HELP - GET PIVOT

2011-05-06 Thread ashish koul
try this (VLOOKUP(MAX(G:G),G:K,5,0)+VLOOKUP(MAX(G:G)-1,G:K,5,0)+VLOOKUP(MAX(G:G)-2,G:K,5,0))/3 On Fri, May 6, 2011 at 5:20 PM, mayur wrote: > Hi All, > > I need help on get pivot formula for getting average of last three days > score. > Please find attached sheet, is more self explanatory. > >