What is the best way to filter table column data if data validation is applied with "warning" and the green error triangle appears for invalid entries?
A good way to start would be by being clear on what you're asking for. And I'm referring to your question here in this forum. Quite frankly, I think the reason you've had no replies despite over 30 views is that it's not even clear what kind of situation you're describing. It would help us help you if you would give us some more details, examples, that kind of thing... Even attach or post a copy of the spreadsheet--on OneDrive or Google Drive, just making sure there's no confidential info in it. And post a link here.