Filter formula based on drop down BUT with an option for all data

[Amo840812]

I have a sheet with data called Combined. I have a second sheet called DC. On the DC sheet there is a drop-down list where I can select a person's name OR select ALL. I can get it to pull the information from the Combined sheet that matches the person's name. but I can't figure out how to get all the data to show if I pick ALL from the drop down.

The easiest solution would be not to use the DC sheet at all, but I don't know if that's even possible since I am pulling the data using Vstack. The combined sheet pulls data from 6 tables using VSTACK. If I could sort right on the Combined tab directly and get rid of DC altogether that would be fabulous.

My Vstack formula:

Total list of items from the combined list:

When selecting a name from the drop down:

When selecting ALL from the drop down:

 

[Vogateer]

Please give us some sample data from your Combined sheet that we can copy and paste, and it would be helpful if you included the formula that you're using for the combined sheet to filter the name.

 

[myall_blues]

As @Vogateer says, seeing your filter formula would be most helpful, but you could do something along the lines of:

=IF($C$1="ALL",VSTACK(LettersTable,...,etc), FILTER(VSTACK(LettersTable,...,etc),filter_range=$C$1,"Not found")

Obviously you need to make the appropriate substitutions in the VSTACK and also use the appropriate filter range.

 

[Amo840812]

Apologies, this is the DC sheet formula currently. It works correctly if I select a name (shows only the rows assigned to them), but not when I select ALL as seen below:

 

[myall_blues]

=IF(C1="ALL",Combined!A5:G500,FILTER(Combined!A5:G500,C1=Combined!G5:G500))

 

[Alex Blakenburg]

If you want to get rid of DC try something like this on the Combined Sheet.
It looks like your criteria are in D1
G is column 7
Put your own Table Names into the VSTACK

=LET(vstComb,VSTACK(Table1,Table13),
     crit,D1,
     IF(crit="ALL",vstComb,FILTER(vstComb,CHOOSECOLS(vstComb,7)=crit)))

 

[Amo840812]

Thank you!! This worked for me!

 

[myall_blues]

You’re welcome. I’m glad we were able to help.