t occurrence of 1.
>
> Regards - Dave,
>
>
>
>
>
> > Date: Mon, 29 Mar 2010 16:38:39 -0700
> > Subject: $$Excel-Macros$$ Question about Index function
> > From: tomfabtas...@hotmail.com
> > To: excel-macros@googlegroups.com
>
> > Hi,
>
> >
nd False's. The double negative outside
the bracket changes these to 1's and 0's, which are then handed to the Match,
which is looking for the first occurrence of 1.
Regards - Dave,
> Date: Mon, 29 Mar 2010 16:38:39 -0700
> Subject: $$Excel-Macros$$ Question about I
Hi,
I have a formula that works, but I'm not sure how the INDEX function
is working:
=MATCH(1,INDEX(--(ATM!$C$3:$AJ$3=6),0),0)
The INDEX part of the above searches for a 6 in the range ATM!$C$3:$AJ
$3.
The -- appears to create an array. Is the -- shorthand for another
function ?
Regards,
Tom
