Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Formula using array to find embedded value | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |