Excel 2003

Is there a way of comparing the value in the current cell, against that
of the rightmost occupied cell in a row range?
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

formula is and format as desired. Assumes numbers

=b2=INDEX($2:$2,MATCH(9999999,$2:$2))



On Jan 23, 12:13*pm, Paul Hyett <vidcap...@invalid83261.co.uk> wrote:
> Excel 2003
>
> Is there a way of comparing the value in the current cell, against that
> of the rightmost occupied cell in a row range?
> --
> Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

On Mon, 23 Jan 2012 at 16:47:32, Don Guillett <(E-Mail Removed)>
wrote in microsoft.public.excel :

>formula is and format as desired. Assumes numbers
>
>=b2=INDEX($2:$2,MATCH(9999999,$2:$2))
>
Thanks - I'll give that a try!
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

On Mon, 23 Jan 2012 at 16:47:32, Don Guillett <(E-Mail Removed)>
wrote in microsoft.public.excel :

>formula is and format as desired. Assumes numbers
>
>=b2=INDEX($2:$2,MATCH(9999999,$2:$2))
>
OK, I've entered it as follows, in a4, with the numbers to test in row 4
in the range of columns as below...

=A4=INDEX($J:$BI,MATCH(9999999,$J:$BI))

But it doesn't work...
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

You didn't include the row (4) in both of your range addresses.

On 01/24/2012 11:34, Paul Hyett wrote:
> On Mon, 23 Jan 2012 at 16:47:32, Don Guillett <(E-Mail Removed)> wrote in
> microsoft.public.excel :
>
>> formula is and format as desired. Assumes numbers
>>
>> =b2=INDEX($2:$2,MATCH(9999999,$2:$2))
>>
> OK, I've entered it as follows, in a4, with the numbers to test in row 4 in the
> range of columns as below...
>
> =A4=INDEX($J:$BI,MATCH(9999999,$J:$BI))
>
> But it doesn't work...

--
Dave Peterson

On Wed, 25 Jan 2012 at 06:34:21, Dave Peterson
<(E-Mail Removed)> wrote in microsoft.public.excel :

>On 01/24/2012 11:34, Paul Hyett wrote:
>> On Mon, 23 Jan 2012 at 16:47:32, Don Guillett <(E-Mail Removed)> wrote in
>> microsoft.public.excel :
>>
>>> formula is and format as desired. Assumes numbers
>>>
>>> =b2=INDEX($2:$2,MATCH(9999999,$2:$2))
>>>
>> OK, I've entered it as follows, in a4, with the numbers to test in
>>row 4 in the
>> range of columns as below...
>>
>> =A4=INDEX($J:$BI,MATCH(9999999,$J:$BI))
>>
>> But it doesn't work...
>
>You didn't include the row (4) in both of your range addresses.
>
So it should have been : =A4=INDEX($J4:$BI4,MATCH(9999999,$J4:$BI4)),
then?
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

On Wed, 25 Jan 2012 at 17:06:09, Paul Hyett
<(E-Mail Removed)> wrote in microsoft.public.excel :
>>
>So it should have been : =A4=INDEX($J4:$BI4,MATCH(9999999,$J4:$BI4)),
>then?

I've changed it to =A4<>INDEX($J4:$BI4,MATCH(9999999,$J4:$BI4)) and now
it seems to have the desired effect - thanks.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)