Thanks Dave - that's excellent.
On Mar 30, 3:35 pm, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
Yes, it works; but it seems much longer than necessary.
I think =MATCH(6,ATM!$C$3:$AJ$3,0) would work just as well.
As to the Index part of the original function:
When the Index
Hi,
Yes, it works; but it seems much longer than necessary.
I think =MATCH(6,ATM!$C$3:$AJ$3,0) would work just as well.
As to the Index part of the original function:
When the Index function has a zero as it's second arguemnt, it reurns the
entire array - in our case, of True's and False's.