1:1 as the Array using the MATCH function
The 1:1 in the array indicates ALL of Row_1.
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Knot2Brite" wrote:
Hello,
I am working on an Excel course from OzGrid.
One of the problem/examples defines the MATCH function Array as 1:1. In my
ignorance I expected something like A1:G50.
I can't find in Help an explanation of what "1:1" defines. I will
appreciate some guidance.
Thanks
Bob
|