View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Uhl Uhl is offline
external usenet poster
 
Posts: 7
Default Array Offset() formula with height of 1 returns duplicates?

Is the Offset() function with a height of 1 supposed to return
duplicate values?

Here's an example starting at cell "A1". The first column has values
"Cat", "Dog", etc.... The second column has the array formula
"{=OFFSET($A$1,0,0,2)}".

Cat Cat
Dog Dog
Bird #N/A
Plane #N/A

That's correct. But when I change the Offset() function's HEIGHT to
"1", as in "{=OFFSET($A$1,0,0,1)}", I get...

Cat Cat
Dog Cat
Bird Cat
Plane Cat

What I really want is:

Cat Cat
Dog #N/A
Bird #N/A
Plane #N/A

What am I doing wrong?