Print

How to solve sort order error: “We cannot sort the ‘A’ column by ‘B’. You cant have more than …”

Have you got this error while trying to sort columns?:

“We cannot sort the ‘school’ column by ‘grade’. You can’t have more than one value in ‘grade’ for the same value in ‘school’. Choose a different column for sorting or update the data in ‘Year’.”

In this video I show you why you get it and how to fix it.

Watch the tutorial:

How to solve sort order error: "We cannot sort the 'A' column by 'B'. You cant have more than ..."

Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents