• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Criteria in query


Well-Known Member
I have an excel query, but I only want the rows where the value in column 5 is less then the value in column 6
How can I set that criteria?



Active Member
Is this PowerQuery? If so, create a custom column that returns Y if column 5 is less than column 6, then filter on that.