U
Uhl
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?
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?