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.