, 29 Mar 2010 16:38:39 -0700
Subject: $$Excel-Macros$$ Question about Index function
From: tomfabtas...@hotmail.com
To: excel-macros@googlegroups.com
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
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
. 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 Index function
From: tomfabtas