sort by column issue

[Muthuramalingam]

Hi 

I am having financial accounts in one column and unique numbers in another column. I have sorted the financial accounts column by unique numbers column. we received the below error. We checked the numbers column, numbers are unique. Please suggest a way to solve the issue

[PaulDBrown · Accepted solution]

The sort column must contain unique values which correspond to each unique value in the sorted column. So if you have two rows with value A, and the sort by column has 1 and then 2, you cannot sort by the sort column. 
All "A" rows must have 1; all "B" rows must have 2 ... and so on