why are you assholes mailing me this shit? o0o sucks anyway
> Date: Sun, 7 Aug 2011 22:09:57 +0200 > From: [email protected] > To: [email protected] > Subject: [discuss] Re: Issue with code > > 2011/8/3 Joseph Da Silva <[email protected]>: > > Hi > > > > Here is the code I am having an issue with in open org works in excel > > > > > > =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0))))) > > > > Have you tried to select that cell and then hit Ctrl+F2? Then you can > easier debug the formula, by placing the cursor in different places of > the formula to see the results of different parts of the formula. > I don't know for sure, but aren't you supposed to use a ”;” > (semicolon) as a parameter separator rather than a ”,” (comma)? Or > maybe both work these days. > > > > > > > There seems there is an issue with the CELL command and using 3.30 version > > on windows 7 > > > > > > > > Any advise would be appreciated. > > > > > > > > Thanks for your time and consideration > > I'm not sure that I helped at all, though… > > > Regards > > Johnny Rosenberg > ジョニー・ローゼンバーグ > -- > ----------------------------------------------------------------- > To unsubscribe send email to [email protected] > For additional commands send email to [email protected] > with Subject: help -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
