Hi Joseph,
On Wednesday, 2011-08-03 02:10:43 +, Joseph Da Silva wrote:
> Here is the code I am having an issue with in open org works in excel
>
> =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$3,MATCH(MAX(Q28933:Q3),Q28933:Q3,0)
> There seems there is an issue with the CELL com
2011/8/3 Joseph Da Silva :
> Hi
>
> Here is the code I am having an issue with in open org works in excel
>
>
> =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$3,MATCH(MAX(Q28933:Q3),Q28933:Q3,0)
>
Have you tried to select that cell and then hit Ctrl+F2? Then you can
easier debug the fo
Could it be that you have 6 closing parenthesis and only 5 opening parenthesis.
Steve
Sent from my iPad
On Aug 7, 2011, at 1:09 PM, Johnny Rosenberg wrote:
> 2011/8/3 Joseph Da Silva :
>> Hi
>>
>> Here is the code I am having an issue with in open org works in excel
>>
>>
>> =INDIRECT(CELL("
Hi
Thanks for the quick reply
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$3,MATCH(MAX(Q28933:Q3),Q28933:Q3,0
The issue is I am getting a 508 with version 3.30 error but works fine with
Microsoft Excel
Thanks
> Date: Sun, 7 Aug 2011 22:03:15 +0200
> From: o...@erack.de
Hi Joseph,
On Sunday, 2011-08-07 21:06:57 +, Joseph Da Silva wrote:
>
> =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$3,MATCH(MAX(Q28933:Q3),Q28933:Q3,0
>
> The issue is I am getting a 508 with version 3.30 error but works fine with
> Microsoft Excel
Err:508 is an "errPairE
@hotmail.com
> Subject: Re: [discuss] Re: Issue with code
>
> Hi Joseph,
>
> On Sunday, 2011-08-07 21:06:57 +, Joseph Da Silva wrote:
>
> >
> > =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$3,MATCH(MAX(Q28933:Q3),Q28933:Q3,0
> >
>
"Joseph Da Silva" wrote in message
news:col111-w130c1cae71485ba4808f2ca0...@phx.gbl...
>Hi Eike,
>
>Thank you for your response I have tried your suggestions and have provided a
>sample file with the formula.
>
>If you have a chance take a look.
>
>Thanks
>
>
>
>
Replace all the commas ("