Dear Mr. Excel,
How does OFFSET work when I'm working with a set of filtered records? =OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,0) gets me the value from the row below. If I've filtered the list however using a value in another column, my OFFSET function won't return the value from the next record in this filtered list. It gets the next value from the full, unfiltered list.
I expect my question has been answered before, but I've not been successful in my efforts (in Google and elsewhere) to locate the answer(s).
Thanks!
How does OFFSET work when I'm working with a set of filtered records? =OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,0) gets me the value from the row below. If I've filtered the list however using a value in another column, my OFFSET function won't return the value from the next record in this filtered list. It gets the next value from the full, unfiltered list.
I expect my question has been answered before, but I've not been successful in my efforts (in Google and elsewhere) to locate the answer(s).
Thanks!
