Not sure if it allowed but I'm reposting since my prev thread may not have been clear...
My problem is that my Excel version doesn't support VSTACK. I basically need to use a function that extracts out info using FILTER but across multiple different row ranges at once.
The problem simplified looks like this:
I'd like the formula to extract out the Wk2 tables only.
So the formula should be able produce this result:
Or this:
However, as you can see, the problem with my case is that the table arrays aren't all in the same 3 rows. I assume If I had VSTACK, I could easily just combine two FILTER formulas that searches through the table arrays B3:J5 and B7:J9 separately. Something like this:
VSTACK(
FILTER(B3:J5, B3:J3="Wk2")
FILTER(B7:J9, B7:J7="Wk2")
)
So is there a way to replicate this formula without VSTACK?
My problem is that my Excel version doesn't support VSTACK. I basically need to use a function that extracts out info using FILTER but across multiple different row ranges at once.
The problem simplified looks like this:
I'd like the formula to extract out the Wk2 tables only.
So the formula should be able produce this result:
Or this:
However, as you can see, the problem with my case is that the table arrays aren't all in the same 3 rows. I assume If I had VSTACK, I could easily just combine two FILTER formulas that searches through the table arrays B3:J5 and B7:J9 separately. Something like this:
VSTACK(
FILTER(B3:J5, B3:J3="Wk2")
FILTER(B7:J9, B7:J7="Wk2")
)
So is there a way to replicate this formula without VSTACK?
