Filter table data by data validation error

Question

Is there a way to filter table data to display only records that have the green triangle that appears when items do not meet data validation criteria?

I tried using the Find - Go To Special feature to go to errors, but apparently, those are not considered errors?

I guess an additional rule could be applied with Conditional Formatting and then we could filter by color, but just wondering if there was a way to do it without that next step.

Answer 1

Hi,

Thank you for querying in this forum.

I go through the post carefully. It seems like you want to filter table data which doesn't meet data validation criteria. You know a conditional formatting rule can help to filter it by color, but you want a different method.

May I know if my understanding of the scenario is right?

If yes, per our tests and experience, we are afraid it may don't have out of box feature in Excel which can filter the data based on the value in the data validation. We do understand it caused inconvenience and feel sorry about it.

If you are willing, you may need to add helper formula column to filter the data.

A similar thread for reference: Filter Data From Drop Down List Selection In One Worksheet With Helper Formulas

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

In the meantime, we will also keep this thread open and welcome other community members who have similar experience share insights and suggestions here.

Thanks for your patience and understanding.

Best regards,

Tina