View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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