Forum Discussion
Filter - Drop down menu to show rows with cells with one or more values
The FILTER function is indeed expandable:
=FILTER(Table1[[Proj Name]:[Random3]],(Table1[StartWeek]<=RequestedWk)*(Table1[LastWeek]>=RequestedWk))
Gets the larger table view (as you can see in the attached). The key is in the red, where it now displays the starting column and the finishing.
It could also be sorted, if that were important. Just nest the FILTER formula within a SORT and specify the column on which the sort is to be based.
I appreciate the precision you're seeking to employ in describing your situation. It's nevertheless difficult to actually picture exactly what you're up against based solely on the words. And although the cliche is that a picture is worth a thousand words, even if you were to post an image of your files, that wouldn't help much.
Is it possible for you to post a copy of the actual workbook (devoid of any personal or confidential info) so that we here in techcommunity can experience it first hand, and maybe offer the solution you're looking for?
