Excel Quick Tip: A Trick for Finding Inconsistent Data

We hope you enjoy!

[adefabrisio]

You are amazing... I appreciate this. I've been trying to find the errors to 700 rows. I also used the filter command but didn't know how to use it. Once again, thank you for this tutorial 🔥❤️❤️💃🏾🔥🔥

[earcandies]

How do you fix if there were 100s of inconsistent data after filter? For example 100s or nrth, 1000s of wst?

[liyaelizabethantony]

Thank you so much! you're amazing

[garyonly]

What if you are dealing with a thousand rows, and hundreds of these errors? Do you still have to go and fix them manually?

[sanmai_patil]

This is exactly what I am looking for but, what is the solution when there is more than 1000k data ? I mean rows

[arutalanala]

Is there any automatic way i can do to fix this because i have to filter data 😭