| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Second item in list using array
Hello--
I'm trying to return the second item in a list using an array. I'm using this to give me the first item in the list. What should I modify to return the second item in a dynamic list. =INDEX(A34:A59,MATCH(1,(SUBTOTAL(3,OFFSET(A34:A59, ROW(A34:A59)-MIN(ROW(A34:A59)),0,1)))*(A34:A59<""),0)) Thanks!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
| I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
| drop down list/typing item from list error | Excel Worksheet Functions | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions | |||
Threaded Mode
