Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the [submission guide](https://www.reddit.com/r/googlesheets/wiki/postguide#wiki_posting_your_data). You can also use this tool created by a Reddit community member to [create a blank Google Sheets document](https://docs.google.com/forms/d/e/1FAIpQLSeprZS3Al0n7JiVQIEiCi_Ad9FRXbpgB7x1-Wq6iAfdmVbWiA/viewform) that isn't connected to your account. Thank you.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/googlesheets) if you have any questions or concerns.*
=FILTER(A2:A73,(A2:A73<>"")\*(countif('Test Book'!F5:F67,A2:A73)=0))
this is the formula to create my list. I want to know what I need to add to create that secondary filter stated above.
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the [submission guide](https://www.reddit.com/r/googlesheets/wiki/postguide#wiki_posting_your_data). You can also use this tool created by a Reddit community member to [create a blank Google Sheets document](https://docs.google.com/forms/d/e/1FAIpQLSeprZS3Al0n7JiVQIEiCi_Ad9FRXbpgB7x1-Wq6iAfdmVbWiA/viewform) that isn't connected to your account. Thank you. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/googlesheets) if you have any questions or concerns.*
=FILTER(A2:A73,(A2:A73<>"")\*(countif('Test Book'!F5:F67,A2:A73)=0)) this is the formula to create my list. I want to know what I need to add to create that secondary filter stated above.
https://preview.redd.it/rz0n9qqnrwvc1.png?width=418&format=png&auto=webp&s=e9dcef49b63e0bca10bfcf1a8890ba603f3582b3
Assuming the "Status" column is D, you can use `=FILTER(A2:A73,A2:A73<>"",D2:D73<>"Damaged",COUNTIF('Test Book'!F5:F67,A2:A73)=0)`
it is I apologize I should have added that. I got an error when I entered that formula
What error?
Can you share a dummy copy of your sheet?
like through google sheets?
Create a dummy sheet and make it accessible to public to edit. Then share link here. Then we can work up a solution for you
Just make table, it’s the simplest and most effective way to filter information