C
CeciliaPDX
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!!!
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!!!