Forum Discussion
Filter rows from 4 sheets based on column value
If you have the most up-to-date version of 365 and are familiar with 3D named ranges, the following should work
= LET(stacked, VSTACK(weeklyData),
FILTER(stacked, CHOOSECOLS(stacked,2)="sad"))
Peter, Thank you for your response.
I have 365 I believe but my Excel won't recognise VSTACK function! I'm on 16.64 macOS version of Excel if that gives any context at all. So that's made the above solution not work for me, even though it looks beautifully straightforward!
I think I'm just going to change what I'm doing, having no luck finding a reliable solution. Even if I could find a way to pull from each sheet separately, by referencing a cell which contains the individual sheet names, but I think my lack of skill was preventing me from doing that, too.
Anyways thank you for your suggestion, I'll return to this perhaps once I see VSTACK in my Excel!
So far VSTACK is only for Office Insiders (Beta and Preview channels).
